Excel & AutoHotkey

Excel & AutoHotkeyExcel & AutoHotkey Tutorials

  1. Create / Connect to Excel with AutoHotkey via COM
  2.  AutoHotkey and Excel Object model: Application, Workbook, Worksheet
  3. Shading cells with AutoHotkey via COM
  4. Obtain First row, Last row, # Used rows
  5. Obtain First / Last Column  & numeric to string converter
  6. Setting Horizontal and Vertical cell alignment
  7. Simplify writing AutoHotkey code using the Macro recorder & Excel constants
  8. Manipulate columns (Insert, Delete, set width)
  9. Insert, Delete, set Height of Rows
  10. Freeze Panes, Toggle screen updating, Inject file name into MRU
  11. Merging, Shrinking, and Wrapping cells
  12. Set cell Number format
  13. Font size, type, bold, italic, underline

Excel & AutoHotkey Examples

  1. SPSS to Excel graph in seconds– Autographs to reduce workload
  2. Automate sales emails
  3. HTML Testing & URL Verification tool
  4. Automating email metrics with RegEx on the naming convention
  5. Automating email metrics -generating whole reports!

Comments are closed