Obtain First, Last and # Used columns from Excel via AutoHotkey and COM

columns from Excel via AutoHotkey

Microsoft’s Component Object Model enables AutoHotkey to easily interact with Excel!  In the below video I used the following functions to obtain First, last and Used columns from Excel via AutoHotkey.  I also demonstrate a few additional functions which allow for easily converting letters to numbers and vice versa.  This makes it easier to program in Excel because you can reference “column M” instead of column 13.

Here are the functions which make it super easy to grab / set columns in Excel


Using AutoHotkey to get Columns from Excel via AutoHotkey

Using AutoHotkey to get Column information from Excel via AutoHotkey & COM