#com object

Excel & AutoHotkey-Replacing Null values in Excel

When some programs export data they will insert #Null! into a cell to indicate there was no data (SPSS to name one).  While I would rather have something than nothing, when trying to compute averages or share data with clients the #Null! value is not ideal.  😦  In this tutorial I demonstrate how easy it is to Replacing Null values in Excel with AutoHotkey.

The following video demonstrates Replaci…

Insert hyperlinks in Email merge using Offset in Excel with AHK

Often I have client data in a spreadsheet and I need to reach out to various clients about the projects I’m working on.   In this example I demonstrate how to use Offset in Excel with AHK.

In the video I mention how I also use Offset in Excel in conjunction with a Outlook to write “pretty” HTML emails.  Here’s the link to a good demonstration of it.

Below is the code I demonstrate creating the…

Insert “pretty” hyperlinks in an Email merge in Excel with AHK

In this Excel tutorial I walk through how to generate a “pretty” hyperlink that is a mail-merge from Excel cells.  This can be very handy when you have, relevant, information for each email that you want to send.

Normally I’d use the offset command and then just select a range however this is the quick/dirty approach.  Having said that, it still gives you a good overview of what is needed.

Code…

Create / Connect to Excel with AutoHotkey via COM

Automating Excel with AutoHotkey is pretty easy however first connecting with the Excel object can be a bit confusing.

This video walks through both connecting with a running Excel application and creating a new one.  It also walks you through how to set the object visible (and use the Task Manager to see if it exists)

Here is the code reviewed in the video:

#SingleInstance,, Force…