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

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

rows from Excel via AutoHotkeyBeing able to use AutoHotkey to automate Excel via COM is awesome!   In this video we walk through using these functions to obtain First row, Last row and # of used rows from Excel via AutoHotkey.

The below video demonstrates how easy it is to, programatically, obtain row information from the active worksheet.

Video walking through functions to obtain rows from Excel via AutoHotkey

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

AutoHotkey and Excel Object model: Application, Workbook, Worksheet

AutoHotkey and Excel Object modelWhile using AutoHotkey to connect to Excel is “easy”, it is also easy to be trying to use call a function to the wrong Excel object.  In this video we discuss the below diagram and explain how to use AutoHotkey and Excel Object model.

autohotkey-and-excel-object-model

Here is the function for specifying which Excel object you want to connect to

Video walking through AutoHotkey and Excel Object model

AutoHotkey and Excel Objects-Application, Workbook, Worksheet

Generate Outlook Address book from all emails in Outlook

Generate Outlook address bookWouldn’t it be nice if you could generate Outlook address book from your email traffic?

This video demonstrates a script I wrote that allows to select which Outlook folders you want to iterates over and then loops over them storing key info like: name, last received email date from, # of emails, Size of attachments, etc.  The script even keeps track of emails you’ve already iterated over so you can run it multiple times yet it only counts the email once.

Generate Outlook address book

Create an Outlook email-addressbook based on email frequency