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? AdvertisementsRead More VBA: How to Extract Parts of Speech in Word
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 […]Read More VBA: How to Jerry Rig an HTML Scraper
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 […]Read More Malware Anatomy: The Anna Kournikova Worm
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.Read More VBA: How to Use VLookUp in a Macro
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.Read More VBA: How to Exclude Numbers from a List
“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 […]Read More VBA: What is a Range Object?