Excel to Twitter

I was inspired by Chandoo's post Write Your Own Twitter Client using Microsoft Excel to take his code and create a userform version. Actually, I was waiting for someone else to do it, since the major portion of the code was written, but since nobody stepped up, I took matters into my own hands. Took me all of half a day to complete, so here it is for anyone who wishes an Excel add-in version of Chandoo's spreadsheet.

Update: Twitter now requires authentication to post tweets. This code no longer works. Download links have been removed.

I'd like to thank Chandoo for putting forth the effort to understand the Twitter API and produce such excellent VBA code, on which this add-in is based. I see he's using his new live.com webspace well!

Instructions:

To load the add-in, open the zip file and place the xla/xlam file somewhere safe. In Excel, go to Tools » Add-Ins and click Browse to look for the file. A new menu item on your Data Menu should appear: Post To My Twitter Account. For those of you thinking of using this add-in at work, consider downloading the unlocked version and changing the application title, so it looks inocuous on your menu. 8)

Screenshots:

Here is the initial screen when you call up the userform:

And here is the completed form, completed with response from Twitter. You'll notice that the password field is blanked out (to prevent nosy shoulder surfers from lifting your password).

When you go to your twitter account from your browser, you'll see the newly added tweet:

My add-in development TAT has increased significantly. It helps to have a stock code library for cutting and pasting purposes. And now that I see the add-ins work in Excel 2007, I might even go back and create XLAM versions of all my add-ins.

Which brings the total number of add-ins available from this site to six! When will it stop?

Thanks to the Twitter API, I could easily see this add-in becoming a full-blown Twitter client. As usual, comments, questions and suggestions are welcome.