YouTube: Tips for Making a How-To Video

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”

VBA: What Exactly is a FileSystemObject?

I really wish Hyperbole and a Half was still posting.

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?”

VBA: How to Code a Letter Frequency Chart

Rolling Stones

I recently picked up a book called “Ghost in the Wires: My Adventures as the World’s Most Wanted Hacker” by Kevin Mitnick. To be totally honest, I’d never heard of Mitnick before. He was a little before my time—when he was arrested in 1995, I was still struggling to understand why the hell I had to learn fractions and everything I knew about computers was based on WarGames.

Continue reading “VBA: How to Code a Letter Frequency Chart”