Home Automation AutoHotKey Archive by category "COM" (Page 28)

Category: COM

COM (Microsoft’s Component Object Model)
https://msdn.microsoft.com/en-us/library/windows/desktop/ms694363(v=vs.85).aspx

Using a strong Naming Convention & RegEx are keys to automating metrics!

naming conventions

Naming Convention and Regular Expression (RegEx)

Having a strong naming convention can make reporting on your metrics a breeze when you use a regular expression to break out-decrypt the naming scheme. This video shows how easy it is for us to extract: Region, Language, Campaign Type, etc. from our campaign names by using a regular expression. It also points out that there is no need to be stuck with poor acronyms for your reporting.Group of coworkers seated around a table in a bright office, talking together with a green reusable water bottle in front of them

In my above example I use AutoHotKey with Excel.  If you add the function, Excel can do RegEx itself however (for some crazy reason) it isn’t built into it.

Automate sales emails with AutoHotKey and Excel

 

Automate Sales emailsAutomate sales emails

I know a lot of very hard-working, but non-technical, sales people.  They spend a lot of time writing personalized emails to clients and spend even more time trying to track the responses.

There some decent mail merge tools on the market however they can be somewhat technical to use (and easy to mess up). I built a short script in AutoHotKey which allows for automating of emails but allows fore proofing & tweaking before deployment.

Web Scraping with AutoHotKey 104- Dealing with the dreaded Frames!

AutoHotkey Merchandise-White Stress ballWhen I’m web scraping info off the Internet and run into Frames I first cry and then say a prayer… The below video helps review the issue and offers some solutions on how to, reliably, grab data.

Just keep in mind that each frame is, in essence, it’s own page and you’ll have to add additional values to your handle to navigate to it.

A copy of the syntax writer for Web Scraping with AutoHotkey can be found here.

Troubleshooting Web Scraping frames with AutoHotkey

Two women in an office smiling at a computer screen, one pointing at it while the other sits beside a green bottle on a desk.