If you live in Australia, you'll need to know the post code for your letters, bills and postcards. Here's some VBA code and a sample app that can help you look up post codes in Australia.
Continue Reading: Looking up Australian postal codes »
Got weather?
Hot on the heels of my update to the Latitude/Longitude functions page, I've written some more VBA code that uses web APIs to retrieve weather information for any zip code in the U.S.A. If you visit that page and then look at the code below, you may notice the similarity.
Continue Reading: Got weather? »
Open or print files in VBA
I've previously posted code for opening any email attachment. See Open Any Email Attachment From Outlook. Note that this technique works for any file and in any VBA environment; they don't have to be email attachments for you to open them.
But you can open OR print any file using the ShellExecute API, and it also works anywhere. The following function can do this.
Continue Reading: Open or print files in VBA »
Shorten urls with bit.ly web API and VBA
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.
Continue Reading: Shorten urls with bit.ly web API and VBA »
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".
Continue Reading: Shorten your tweets with a bit of VBA »
Follow Me