Automate Excel and AutoHotkey
I have a lot of examples using Excel & AutoHotkey. You might like to check out my AutoHotkey Excel Function library. While it isn’t all complete, there is a lot that can simplify your life! If you’re new to AHK, check out our AHK & Excel Webinar. Look here If you’re new to using AutoHotkey functions
Get the Excel Function Library
Automate Excel and AutoHotkey Tutorials
- Create / Connect to Excel with AutoHotkey via COM
- AutoHotkey and Excel Object model: Application, Workbook, Worksheet
- Shading cells with AutoHotkey via COM
- Obtain First row, Last row, # Used rows
- Detecting Used Range (first column, last column, first row, last row, etc.)
- Obtain First / Last Column & numeric to string converter
- Setting Horizontal and Vertical cell alignment
- Simplify writing AutoHotkey code using the Macro recorder & Excel constants
- Manipulate columns (Insert, Delete, set width)
- Insert, Delete, set Height of Rows
- Freeze Panes, Toggle screen updating, Inject file name into MRU
- Merging, Shrinking, and Wrapping cells
- Set cell Number format
- Font size, type, bold, italic, underline
- Adding / Removing / Changing Borders in Excel
- Creating “pretty link” for email merge from data in cells
- Using Offset and a range to iterate over cells and create a “better” email merge
- Finding & Returning specific header locations (for use in Filtering, Sorting, Merging, etc.)
- Clear Excel: Content, format, Data, Notes, comments, etc.
- Leverage built-in Excel worksheet functions & pass a method as a parameter (simplify code maintenance)
- Renaming, Moving, Activating, and Changing the color of Worksheets / Tabs
- Delete an entire Column or Row based on a Value
- Easily Loop over Cells in Excel by using a For Loop in AutoHotkey. I also demonstrate how to detect what’s selected in Excel
- Copy a range to the clipboard or a variable from Excel
- Various ways to Paste in Excel (Think of Paste Special but progromatically doing it)
- Selecting a Cell / Range of Cells
- Inserting and Deleting Comments / Notes
- Inserting and Deleting Worksheets with Excel and AutoHotkey
- Inserting and Deleting Hyperlinks
- Creating personalized emails. Also see our Outlook webinar
- Search & Replace values
- Multiple Search / Replace values. Also delete #Null!
- Find value and return location (Also allows for finding the nth instance of it)
- Find multiple text values in Header row and return their locations
- Deleting blank columns and/or Rows
- Sorting Columns in Excel with AHK
- Sorting Rows
- Remove Duplicate Rows
- Setting and Filtering data in Excel
- Get and Set value on a specific worksheet
- Connect to or Launch Excel. Also how to change it’s visibility and Close workbook and Quit Excel and AutoHotkey
- Opening various file types (XLS, XML, CSV, TSV/TXT, XLSX, and HTML) in Excel
- Saving Excel files in various file types (CSV, Tab Delimited, XLSX)
- Using AutoHotkey text functions in Excel
- Finding the Last Row in a specific Column
- Text to Columns is a great feature in Excel. Here’s how to leverage it with AutoHotkey
- Creating graphs with VB Excel Macro and adapting to AutoHotkey syntax
- Using a SafeArray in Excel
- AutoHotkey webinar using String functions on Excel content. More on strings here
- Performing a vLookup in Excel with AutoHotkey
- Get Excel Meta data with AutoHotkey
- Get various paths from Excel
- Creating an editable listview using Excel
- Inserting and Calling Excel Functions
Excel & AutoHotkey Examples and demonstrations
- SPSS to Excel graph in seconds– Autographs to reduce workload
- Automate sales emails with Excel & AutoHotkey
- HTML Testing & URL Verification tool
- Automating email metrics with RegEx on the naming convention
- Automating email metrics -generating whole reports!