A recent visitor to the site sent me some code that generates tiny urls programmatically. It uses the Internetexplorer.Application object to automatically insert text in the appropriate text boxes on tinyurl.com and submit the form to generate a shortened URL.
Post email data to the Web
In Outlook VBA macro to post email body to the web, Jeremy Slade posts an Outlook macro to publish emails to a web server.
The code uses the XMLHTTP Object to send POST data to a specified URL. I'm not familiar with the actual site being used, but the XMLHTTP object leads me to believe the interface is super fast.
Twitter From Word too!
Someone took out the Twitter stick and hit Microsoft Word as well. Enjoy this version of the MS Office Twitter client at word + twitter. The page is in Hungarian but if you use a translation service, you can make it through well enough. Just download the Word doc in the post and take it out of design mode.
http://legalalien.org/blog/index.php/2009/02/15/word-twitter/
Update 7/16/2009: The page seems to have disappeared. But it's easy to recreate the Twitter code in MS Word. If anyone wants it, let me know.
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.
Follow Me