VBA: How to Get a Spreadsheet of File Names

VBA Header

I recently found a really cool article from Software Solutions Online that shows you how to get a list of files in a folder or a list of subfolders in a folder. All the things, basically.

This weekend, I’m adapting that slightly to get a complete list of files within a folder including everything in its subfolders. I know. This is the sort of thing that’s either really interesting or really not, depending on how much you use VBA.

Continue reading “VBA: How to Get a Spreadsheet of File Names”

VBA: How to Return the Last Row and Column in Excel

VBA Header2

I was done with this week by about noon on Monday, so I’m four and a half days overdue for a Jessica Jones marathon.

Which is why I’m keeping this short and sweet. This week, I learned how to return the last row and column in an Excel spreadsheet. It’s insanely helpful if you want to copy and paste the same information to multiple workbooks using VBA.

Continue reading “VBA: How to Return the Last Row and Column in Excel”

VBA: How to Write Your Own Function

VBA Header

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 on a string that’s only going to affect one cell, go with the UDF. Sounds like a terrible disease, doesn’t it? In Excel, it stands for User Defined Function.

Continue reading “VBA: How to Write Your Own Function”

VBA: How to Code a Polygon Coordinates Importer

vba-header

Somehow, a few weeks ago, no doubt as a result of my having enough caffeine in my system to  down a small hippopotamus, I thought it would be a good idea to make a KML to CSV exporter in AutoHotkey. I can’t even claim ignorance this time—I knew VBA was a thing. But the neurons firing in my brain blazed right passed the LOGIC center and crashed head on into the AHK FIXES EVERYTHING node.

Continue reading “VBA: How to Code a Polygon Coordinates Importer”

Processing: How to Add CSV Data to Pretty Maps

header

The internet has a shit-ton of map data. I didn’t realize it until I started skimming through HTML on sites like Craigslist and Yelp. Yes, by the way, I am that weirdo who sits in coffee shops on Saturday mornings muttering at tags I don’t understand.

The point is, I want to be able to play with that data in Processing. The first step is just getting that information into the sketch and mapping it properly. That’s what I’m doing today… I acknowledge that I get fixated on projects with very few practical applications. It’s possible I need to get out more.

Continue reading “Processing: How to Add CSV Data to Pretty Maps”

AHK: How to Fix an Airbnb Scraper

webscraper1

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 is how I’m gathering data for all the other scripts I’m trying to write, I spent the weekend fixing it.

Continue reading “AHK: How to Fix an Airbnb Scraper”

VBA: What? Just… What?

whatisthismadness

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 lines that’ll transfer a cell from one workbook to another.

*Is fuck-ton hyphenated?

Continue reading “VBA: What? Just… What?”