Archive for September, 2008

Blog Maintenance

Tuesday, September 30th, 2008 60 views

I'll be doing some blog maintenance in the next few days. The code highlighter blows, so I'm replacing it with one that can also be used in the comments. That means I have to go through all 75+ posts and change the code to display the VBA properly :( And I'm ...

Save attachments and send clean emails

Sunday, September 28th, 2008 285 views

    Do you ever need to forward attachments to someone else (maybe your boss), but don't want the ugliness of "FW: FW: re:" in the subject line? Why let others choose how your emails are going to appear -- here's an amalgam of code I've posted previously (mainly from Processing multiple ...

My Excel User Conference Experience

Friday, September 26th, 2008 230 views

    As you might have read in my post Excel User Conference Update, I attended the Thursday session of the Excel User Conference. Due to work constraints (which I will discuss below), I was only able to attend one day of the conference. I return home exhausted, more learned than I ...

A simple sheet changing add-in

Tuesday, September 23rd, 2008 104 views

    I wrote a small add-in that lets you switch between worksheets easily. Just download the XLA file, place in your favorite directory, and go to Tools > Add-Ins and browse for the file.     When installed, a menu item on the Windows menu called "Sheet Picker" is added. A form with a ...

Hold that email!

Friday, September 19th, 2008 201 views

    In Delay Sending Outlook Messages, Debra Dalgleish writes about deferring delivery times for Outlook messages: You hit Send, then realize you forgot the attachment. Or you misspelled the recipient’s name. Or you used Reply All, when you only wanted the message to go to one person. None of these things have ...