Last week, I wrote a function that loops through all the characters in the first paragraph of a Google Doc. But chances are, if you’re running through all the characters in a paragraph, you’re going to need all the characters in all the paragraphs.
How the heck do you do that?
Did you know Google Docs are equipped for macros?! Meaning you can script some automation right into Google. Best thing since sliced bread.
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”
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 foul language because YouTube does not take kindly to that.
I did that after doing a lot of other research on the basics of YouTube for a non-YouTuber.
So, as a supplement to this VBA video tutorial, I’ve condensed my background research for anyone out there who might also be considering a jump from WordPress to YouTube.
Continue reading “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 her computer.
She will, however, open up a Word document no questions asked.
Continue reading “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 Anna Kournikova and the Love Bug, which I’ve been looking at recently. So here’s how to make a FileSystemObject.
Continue reading “VBA: What Exactly is a FileSystemObject?”
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.
Continue reading “VBA: How to Customize Font to Specific Text in Word”
I think I’ve mentioned it before that the Python documentation can be really confusing for beginners. There may be people out there who can look at this Table objects page and completely understand what’s happening.
I am not those people. I need visuals.
Continue reading “Python: How to Deal with Tables 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.
Continue reading “VBA: How to Use VLookUp in a Macro”
Every time I start thinking that my job is bad, I try to remind myself that Stanley Kubrick had a secretary. The guy was notorious for driving actors into the ground. Making them do takes over and over and over. Can you imagine having to handle his administrative work?
If IMDB’s trivia page is to be believed, that poor soul had to spend weeks typing out the infamous ‘All work and no play makes Jack a dull boy’ novel from hell. On the off-chance I ever find myself similarly working for a maniac, I’m attempting to master the Python docx module, and I’ve been pleasantly surprised with how far you can get with just the basics.
Continue reading “Python: How to Automate Word Docs”