For the genuinely confused.
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?
Continue reading “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 her computer.
She will, however, open up a Word document no questions asked.
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 so old it’s unlikely anyone would be able to use this walk-through to create something malicious. Old in malware years anyway. In human years, she’ll be seventeen next month.
Continue reading “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.
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.
“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 typing?
