Turns out you can shorten URLs easily with bit.ly. In More XMLHTTP Web API examples I mentioned that it was difficult, because bit.ly returns an XML document which must be parsed for the response.
Shorten your tweets with a bit of VBA
The web API madness continues: If you find yourself running out of space on Twitter, Tweetshrink has an API you can use to return a shortened string of whatever you pass to it. You can use this in tandem with the URL shortener and Twitter posting code to create a robust Excel-based Twitter application. I can't believe I just wrote "robust Excel-based Twitter application".
Working with the del.icio.us API in VBA
Automate Excel has some useful code samples (as well as a cool domain name which I'd love to own). One of them is a workbook containing code for importing del.icio.us bookmarks into Excel. Unfortunately, the code seems to be broken and the blog hasn't been updated in months. So I downloaded the workbook, made a few changes, and humbly present to you my version of the workbook.
Continue Reading »
Follow Me