Freeze panes in Excel, Toggle screen update and MRU list via AutoHotkey

This video coverFreeze panes in Excels how to Freeze panes in Excel, Toggle screen updating (which can drastically speed-up your script) and inject a file name int the MRU (Most Recently Used) list of files.

This video walks through how to use the below AutoHotkey functions.  Be sure you check out how to get a handle to Excel which is covered in this video.

Freeze panes in Excel, Toggle screen updates & insert file into MRU

Frezing panes, Toggling screen update and MRU List in Excel via AutoHotkey

AutoHotkey code demonstrated in Video

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

SPSS to Excel graph in seconds– Autographs to reduce workload

SPSS to excel graph

Typically I used to use SPSS to create tables then export them and graph them in Excel (because Excel makes darn pretty graphs!)

A few years back I wrote a script that would, automatically, take SPSS tables and create the graphs for me.  This brought down my reporting time to minutes instead of hours!  Using AutoHotKey I was able to take SPSS to Excel without embedding any macros.  This is possible because AutoHotKey can connect via a COM object.

SPSS to Excel graph in seconds

AutoGraph in Excel

 

 

Automate Excel graphs with AutoHotKey and SPSS; Automating pretty charts!

Automate Excel graphsAfter 20 years of doing multivariate statistics, doing analytics is very quick and easy for me.  Putting together the report which clients will think is “pretty” and convey the results is what really takes the time!  I have a ton of macros in SPSS which greatly simplify the front-end however I’ve always preferred Excel graphs to SPSS (because they don’t look like they were drawn with crayons).

Automate Excel graphs

In the below video I demonstrate how you how you can use AutoHotKey to easily automate Excel graphs that you’ll be proud to put your name on!

Using AutoHotKey to Create Excel Graphs