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
Animated textures in Blender is a thing! Immediately after finding that out, I set out to script a grid crawler texture in Processing. Because no one in their right mind would want to draw that by hand. A Bit Of Everything has a post with the logic for a static grid, but somehow getting an […]Read More Blender: How to Loop an Image Sequence into Textures
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 […]Read More Python: How to Automate Word Docs
So last week, I learned that VBA buttons are supremely helpful. For moving data between workbooks or breaking down information from a KML file, these are ideal. Especially the KML file importer because it’s basically populating a full on spreadsheet. But if you want to have a function run very specific math or customized scraping […]Read More VBA: How to Write Your Own Function
Just when I thought I was going to have a nice, relaxing Processing weekend, I realized my Airbnb scraper is broken. Fun fact: If they change their HTML, this script is WILDLY unlikely to work. I’m getting the sense that Airbnb is going to be the wild duck to my Sumatran tiger. Since the scraper […]Read More AHK: How to Fix an Airbnb Scraper
I know shockingly little about Excel. And that is somewhat unsettling because most of my jobs, which I depend on for food and rent and coffee, require a fuck-ton* of spreadsheets. In the interest of keeping myself rolling in coffee grounds, I’ve made myself sludge through VBA tutorials this weekend and put together a few […]Read More VBA: What? Just… What?
For future reference, I’m posting the code at the top. Details follow below. STEP 1: Make a new AutoHotkey file. Don’t know what that is? Don’t worry. It’s real easy. Click here. STEP 2: Go into your C Drive. Make a folder called Folders1_200. STEP 3: Right click your new AutoHotKey Script → Edit Script.Read More AHK: How to Make a $hit Ton of Files in 60 Seconds