VBA: How to Customize Font to Specific Text in Word

Header2

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

Advertisements
Tagged , , , , , ,

How to Install GAP for Gifs

Header

GAP stands for Gimp Animation Package. It’s the way that I make gifs out of MP4 files. Here’s a breakdown of how you can install it into your version of Gimp in six steps.

Continue reading

Tagged , , , , , , ,

Python: How to Write a Web Scraper

Header

Back from vacation! I did a version of this in AutoHotkey a while back, but this one’s in Python. It does require importing modules—check out this post for that. You’ll want both requests and beautifulsoup (I’m using beautifulsoup4) before getting started.

Continue reading

Tagged , , , , ,

Python: How to Deal with Tables in Word

Header

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

Tagged , , , , , ,

Arduino: A GifGuide to Parts

Header

I get approximately 2 sentences into most Aduino guides before becoming a giant ball of rage because I have no idea what’s going on. The terminology has been a serious barrier to entry for me. So I decided to take a break from scripting to make a guide for all the fun bits that come in an Arduino kit.

Continue reading

Tagged , , , ,

Python: How to Write an Intersect Analysis to a Text Document

Header

So here’s a quick thing to note before we get started. Python will throw a shit-fit if you do not have everything properly formatted. Indentation matters. I can’t figure out how to make WordPress format my tabs, so if you do copy and paste the below code, indent the loops to avoid errors.

Continue reading

Tagged , , , , , ,

VBA: How to Use VLookUp in a Macro

Header

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

Tagged , , , , , , , , , ,