VBA: How to Extract Parts of Speech in Word

Here’s a fun trick for all you VBA grammar enthusiasts out there. All 6 of you. There exists something called a SynonymInfo Object. It lets you access things like definitions, synonyms, antonyms, and parts of speech in Word. Cool beans, right?

VBA: How to Jerry Rig an HTML Scraper

I’ve found that many people see Python, the programming language, much the same way they see Pythons, the scary-ass snakes. If you haven’t dealt with it before, chances are you’re going to think it’s not to be trusted. There’s no way I could convince my mom, for instance, to open up a .py file on […]

Malware Anatomy: The Anna Kournikova Worm

I don’t advocate the use of viruses, worms, Trojan horses, ransomware, or anything else that can screw up someone’s system or violate their privacy. It’s oddly satisfying to peak inside them though. Like disassembling a clock. Kournikova was my first pick because she’s written in Visual Basic, which isn’t too painful to read. She’s also […]

VBA: How to Use VLookUp in a Macro

Alright, here’s something I’ve been meaning to learn for weeks. It’s probably going to be the most boring post of all time for anyone who isn’t an Excel nerd. In fact, if you aren’t an Excel nerd, just run. Run far, far away.

VBA: How to Exclude Numbers from a List

Alright, I ran short of time this week, so I don’t have a tutorial. But I DO have another fun UDF (User-Defined Function)–this one takes two parameters. Both need to be strings made of comma separated numbers. The function excludes the second set of numbers from the output.

VBA: What is a Range Object?

“Range object” is an unnecessarily intimidating term for a collection of cells within your workbook. Say you need to run some complicated math or formatting over the same cells over and over throughout a long script. You could call on the column number and row every damn time, but who wants to do all that […]