AutoHotkey Webinar: 10/18/2016

AutoHotkey webinarAutoHotkey Webinar Videos and Links

  • Here is a link to video of the First hour (Thank you Joe W for providing this.  I forgot to record the first hour!)
  • Video of Second hour where we chit-chat about how to best solve some problems.

Link to AutoHotkey Webinar resources:

 Resources covered during AutoHotkey webinar

 Featured Script- Toggle to other monitor

AutoHotkey webinars are planned for the third Tuesday of each month.  Signup to future webinars here

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

Programmatically interact with the SciTE editor via COM objects

SciTE editor via COM objects

SciTE editor via COM objects

SciTE is a great IDE that I use with AutoHotKey, SPSS, SQL, Python, XML, HTML, etc.   I love being able to use regular expressions in it to manipulate text and it has some very cool capabilities.  This video is one of my favorite demonstrations how powerful SciTE can be at manipulating text.

Here is a short tutorial and demonstration on how to manipulate SciTE editor via COM objects and Windows commands with AutoHotKey.

 

SciTE editor via COM objects- Editor Windows Commands

A specific version of the SciTE editor for AutoHotKey can be downloaded here and more generic documentation can be found here.