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.

Published by Allyn

A writer, editor, journalist, sometimes coder, occasional historian, and all-around scholar, Allyn Gibson is the writer for Diamond Comic Distributors' monthly PREVIEWS catalog, used by comic book shops and throughout the comics industry, and the editor for its monthly order forms. In his over ten years in the industry, Allyn has interviewed comics creators and pop culture celebrities, covered conventions, analyzed industry revenue trends, and written copy for comics, toys, and other pop culture merchandise. Allyn is also known for his short fiction (including the Star Trek story "Make-Believe,"the Doctor Who short story "The Spindle of Necessity," and the ReDeus story "The Ginger Kid"). Allyn has been blogging regularly with WordPress since 2004.

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 *