On Mad Macro Coding Skillz

At work on Fridays, we have a weekly production meeting for the department. It’s a “Who’s working on what” sort of meeting, as the managing editor of each publication goes over what topics and/or articles their publications are covering in the next week or two, or updates are given as to the status in the production cycle on each. For the most part, the meeting is geared toward the online publications.

Sometimes the meeting lasts fifteen minutes. Sometimes it lasts an hour and a half. It just depends on what’s going on.

This week’s meeting was a forty-five minute meeting.

And, strangely, I contributed.

An idea was being kicked around for some new online content. Valid points were being made, but the thinking was that the content wouldn’t really work.

So I said, “Wait. What if we did this instead? I’m already producing this data, and we do absolutely nothing with it.”

Suddenly, this seemed like a very wise idea, and just as suddenly I had a new responsibility on my plate.

But how to format the information efficiently?

A table!

And it’s in Excel.

So I put my mad Excel coding skillz to use.

I wrote a macro to take the standard spreadsheet that I generate every month (because it’s in my list of things-to-do once a month) that I do nothing with, and I concatenate a few columns, delete out the extraneous columns, rename the column headers, and then…

The macro puts in HTML table tags.

I save the spreadsheet as plain text, load it in Word, change the tabs to hard returns, and then, bam! I have an HTML table ready to go.

I cracked open a Sam Adams Black Lager, put some jazz in the stereo, and started coding. Oh, I wrote in a nasty bug, and I didn’t even catch it, but it’s fixed now. There’s just something relaxing about Sam Adams, jazz, and Visual Basic.

I don’t really even like the Black Lager, by the way.

But the marco? It’s kinda sick, actually, how well this works.

It’s… sick. I mean, really. Just sick.

Sorry, sometimes I surprise even myself. This is one of those times. 😆

I still have to document it. But that can wait.

What the bloody grife am I listening to? Oh, oh. “I Want You (She’s So Heavy),” done in a jazz style. It sorta works. Sorta.

2 thoughts on “On Mad Macro Coding Skillz

    1. Just for that, I’m going to code a dialogue box for the macro that outputs, yes, “Fo’ shizzle!”

      I have a Word macro that turns all the text in a document black. (It’s because I’m lazy; I could do a select all and then change the color, but that’s too much work.) The macro is called “Paint It Black” and it outputs the lyrics to the Stones song in dialogue boxes.

Leave a Reply

Your email address will not be published. Required fields are marked *