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.

Automating email metrics w/AutoHotKey, Excel, & RegEx on the naming convention

Automating email metrics

Automating email metrics

I’ve written an AutoHotKey script that logs into our vendor website and uses web scraping exports the recent email campaigns then breaks them out by region, campaign type, Business Unit, etc. and links them back to our SharePoint site for more information.

 

What’s really cool is that I’m putting in formulas (not the static number) thus if some of the items that  are not classified (someone incorrectly used our mailing name so the RegEx broke) they can go back and update the code and all the numbers will adjust!

Automating email metrics

Automating email metrics