Create / Connect to Excel with AutoHotkey via COM

excel-with-autohotkey

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:

Creating & Connecting to Excel with AutoHotkey via COM

Creating & Connecting to Excel with AutoHotkey

AutoHotkey Webinar: 8/30/2016

AutoHotkey webinarAutoHotkey Webinar Videos and Links

Link to AutoHotkey Webinar resources:

Additional resources mentioned in AutoHotkey Webinar

Here is a link where you can register for upcoming AutoHotkey webinars

Save a ton of time by uploading a contact list using SilverPop API and SFTP

SilverPop APIUploading a contact list to Engage can be time consuming using their web interface.  Even when I focus on the task, it takes from 7-10 minutes.

SilverPop API

Most don’t know that SilverPop API is a decent API webservice.  Tie it in with a SFTP (secure file transfer) and suddenly your uploading lists in about 5 seconds!

While the video is a couple of minutes long, the actual work involved is only a few seconds. After uploading the list, the script launches a separate checker to see when the data job completes and then writes my confirmation email for me.

Uploading a contact list ot Engage via an API call

 

Great function for sending text to the SciTE Output Pane

SciTE Output paneWhile I predominately view text with Message boxes in AutoHotkey, sometimes they are not the right tool for the job.  I wrote a short function to automate sending text to the SciTE Output pane.

SciTE is a great editor however the Output pane is greatly underutilized.  Below is the function I wrote to manipulate it

SciTE Output Pane AutoHotkey Function

And here is a short video walking through how to use it

Sending Text to the SciTE Output Pane