Back in 2005 I’d moved to Oklahoma City, OK to be the Director of Research for Six Flags. Shortly after moving their I’d purchased my first home and was learning how, every weekend, was filled with new chores.
When spring hit, I learned I had a drainage problem in my back yard as it would turn into a mud-pit after a medium rain. A friend recommended I call “Mr. Rooter” to investigate putting in a French drain.
The owner (presumably Mr. Rooter) came out and examined the problem. He told me that he could, in fact, put in a French drain however it would merely be masking the problem. The real problem was that the majority of my roof dumped water into the backyard, and I didn’t have gutters. If I were to get gutters and divert the water, I wouldn’t have the drainage problem.
I thanked him for his time and offered to pay something for his trip out however he was adamant that he didn’t want any money for his time. I told him he’d made a “customer for life” as now I trusted him.
Very few people offer valuable free advice. Nor are they likely to suggest an approach that doesn’t make them money.
It’s one of the things I’m very proud that we also do. We often have calls where we help people and will suggest an alternative method if we’re not a great fit for the project. We’re truly doing consultative work. It’s also why our AHK Courses offer 200% money back guarantee!
Now on with the show…
Understanding a COM object, DLLs, Classes & Functions
While not specifically on Excel, our Functions, Classes & COM object course can give you a great start into Object Oriented Programming. Don’t forget, our courses come with an amazing 200% money back guarantee!
Advanced tips on Selecting text from the Keyboard
This morning I released another extract from our Rise Above PC Incompetence course. In this video we show some great ways to select text with the keyboard. This course is a great way to level-up your skills and become a power user! Don’t miss it!
How to Easily Identify Overlap in Lists
When I worked at Texas Instruments I created a simpler version of this script to easily compare two lists. The version I demonstrate in this video has been converted to AHK v2 but added some extra bells & whistles. Now you can decide if you want to do the comparison case insensitive as well as trim the white-space from each row. We also leverage our amazing v2 Notify class to show you the contents of what is copied when you hit the hotkey. You can grab both versions of this script here.
Your first Hotkey in AHK v2
In this extract of Intro to AutoHotkey v2 we show you how to setup your very first Hotkey! If you don’t know, Hotkeys are why the creator started AutoHotkey. People from AutoIt didn’t see the value and didn’t want to add them so he ported AutoIt to AutoHotkey and a legend was born! Hotkeys in V2 are a little more complicated to setup but you can get the gist of it watching this video.
📚 What we’re reading
- How to Set ChatGPT as Your Default Voice Assistant on Android
- 6 ways to Use Old Hard Drives
- What Is an OPUS File
- How to Copy Styles Between Word Documents
🤖 AI / Chat GPT-3 News / Usage
- Introducing Sora — OpenAI’s text-to-video model
- GPT-4’s New “Memory” Feature Is Stunning
- OpenAI’s Simulator STUNS the Entire Industry
There’s a time to question everything and a time to “gette’r done”. Make sure you realize which is appropriate for you at that moment and do it❗
🤣 A spot of Humor Be honest: Is this YOU?
What we 🅰utomated this week with AutoHotkey #33
This week while going over some tools we’ll be releasing soon I discovered some bugs. An important rule to remember is the more functionality you add, the likelihood of bugs increases exponentially…
They also have access to exclusive & pre-released content and a 3 hours a week where we help people with their AHK issues (the Saturday calls are geared towards people new to AutoHotkey.)
🗣️ 💭 Quotable quotes
- Ideas fade away if you don’t write them down — Dan Kennedy
- Give me 6 hours to chop down a tree and I’ll spend the first 4 sharpening the axe — Abraham Lincoln
- A major reason for procrastination and lack of motivation is vagueness, confusion, and fuzzy minded thinking about what you are trying to do and in what order and for what reason — Brian Tracy
- The true price of anything you do is the amount of time you exchange for it — Henry David
Do you know someone that would benefit from learning useful automation tips like the gems in today’s issue? Take a second and forward this newsletter and bask in the glow of their undying gratitude. Was this email forwarded to you?
Sign up for this Newsletter here. We never share your email with anyone. Ever!
Joe, Isaias, Irfan, Rizwan and staff
P.S. It’s sad to me that most businesses don’t put their customer’s needs before their own. When you put the customer’s needs before your own you’ll never have a hard time finding work. When you put your needs before others you’ll constantly be needing to feed your business with new clients. Give us a try and, I guarantee, you’ll have an amazing experience❗