The site formerly known as Code For Excel and Outlook
October 26, 2011 by · 
Sometimes you may need to check the header response when doing a web query. MSXML lets us do this fairly quickly.
Normally we use GET or POST requests to grab responses from a website. But there is another option (are there more?): HEAD requests. These requests return just the headers from whatever URL you call. This way, we can check if the request is well formed or if the website is available prior to making an actual request.
Continue Reading: Checking header responses »
February 14, 2011 by · 
What's this, another URL shortener? This one comes with a twist — it's an API to an API.
See, you can access numerous other URL shorteners using this one API. Let's see what we can do with this one.
Continue Reading: One API to rule them all »
June 15, 2010 by · 
World Cup fever is here!
In FIFA Worldcup Excel Spreadsheets Roundup, Chandoo has some links to useful World Cup tracking workbooks. Only one of them (the first one) can update scores for you, but the workbook code is locked. I'm not sure what method it uses, but here's one way to get realtime scores for your World Cup 2010 tracking workbook.
Continue Reading: How'd They Do That: Realtime World Cup Scores »
November 19, 2009 by · 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 »
October 19, 2009 by · 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 »
Site last updated: February 8, 2012
Follow Me