Tag Archives: Coding

VBA: How to Get A List From a Range of Numbers

Header

A couple months ago, I did the exact opposite of this. I called it the ListToRange() Function. It’s weirdly helpful at work because I have to go back and forth between having numbers listed out and then having them clustered for other things.

Continue reading

Advertisements
Tagged , , , , , , ,

Processing: How to Make Transparent Textures

Alice

After a long vacation, a wedding, a bad flu, and a whole mess of planes, trains, and automobiles, I’m back to talk about textures. I love playing with transparency in scenes, but scripting transclucency is a bit unusual in Processing. The normal Processing canvas doesn’t support an alpha channel, so it requires something called PGraphics().

Continue reading

Tagged , , , , , , , , , ,

Blender: How to Loop an Image Sequence into Textures

Animating Blender Textures With Processing

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 animated version ate 3 hours of my life. All in all, it took about 12 tries. What I love  about Processing is that even bad guesses can have pleasing results.

Continue reading

Tagged , , , , , , , , ,

Python: How to Automate Word Docs

Header

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

Tagged , , , , , , , , , , ,

VBA: How To Auto-save Attachments in Outlook

GG2C 1

So this week I wrote a script that will take an email from your Outlook and save all the attachments to a specified file. It was a learning process that took many unexpected twists and turns. There was a fair amount of cursing, cajoling, and a minor panic attack. Ultimately the bastard functions though, so I’m calling it a net gain.

Continue reading

Tagged , , , , , , , , ,

Python: How to Install 3rd Party Modules without the Command Prompt

Header

FINALLY. After weeks of errors and several bottles of wine, I managed to load a 3rd party module to get some more Python going.

Continue reading

Tagged , , , , , , ,

VBA: How to Use Dictionary Objects in Excel

A Deranged Alphabet Generator

Ok, I’ve been dancing around dictionaries in VBA for weeks—mainly because they seemed confusing. And I’m lazy. Turns out, they are supremely helpful storage devices. If say, you want a randomly ordered alphabet (otherwise known as a deranged alphabet) for a simple substitution cipher, the easiest way to store each letter with it’s new associated value is with a dictionary.

Continue reading

Tagged , , , , ,