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?Read More VBA: How to Extract Parts of Speech in Word
This is my first and possibly only foray into the madness that is constructing a YouTube video. I’ve been watching the Vlog Brothers for years, and I’ve never appreciated the effort that goes into it. Pick a topic, write a script, animate the graphics, trim clips, find background music, and also, cut around all your […]Read More YouTube: Tips for Making a How-To Video
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
It’s friggin’ magic. FileSystemObject is how you run scripts on your files and folders in VBA. You want to create 100 files on your desktop automatically? It’ll let you do that. You want to delete files with specific names in a directory? It’ll let you do that too. It’s also pretty crucial to viruses like […]Read More VBA: What Exactly is a FileSystemObject?
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
Short one today. I’m getting ready to write a post on worms and realized it’d be really nice if Word could mimic the font formatting that happens in the Visual Basic editor. Color coding helps me see relationships a lot easier when I’m trying to get my head around another person’s script.Read More VBA: How to Customize Font to Specific Text in Word
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