VBA icon

How'd They Do That: Realtime World Cup Scores

world cup logo

World Cup fever is here!

soccer ballsoccer field

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 »

VBA icon

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 »

VBA icon

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 »

learn excel dashboards