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: How to Jerry Rig an HTML Scraper

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

Processing: How to Script Spanish Verbs and Pronouns

A Processing Guide

I’ve been on siesta for about a month now, so today I’m starting a new series. This one is going to be an experiment in building language-learning scripts.

Picking up a second language is really friggin’ hard.  There are apps, but those seem to be tailored for total beginners. I took Spanish in high school, so I remember a lot of the rules. I don’t want to build from the ground up. I want something closer to a crash course. An interactive one.

So I turned to Processing.

Continue reading “Processing: How to Script Spanish Verbs and Pronouns”

Blender: How to Scale Down Coordinates for a Map Scene

A GifGuide 2 Maps

Getting coordinates to scale properly to Blender units has been extremely frustrating for me since I started attempting more 3D maps. So, finally, in a fit of rage this weekend, I wrote a function to do it for me.

It scales the latitude and longitude down along the Z (height) and X (width) axes, taking into account the size of a base map oriented along those axes. In my version, it places a sphere at each coordinate set, but that can be easily changed to other objects.

Continue reading “Blender: How to Scale Down Coordinates for a Map Scene”

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

Malware Anatomy: The Anna Kournikova Worm

Header

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”