Custom Office Programming and Automation
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.
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".
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 »
Copyright © 2013 Jimmy Peña · Hosted by FutureQuest · Powered by Genesis · Legal
Follow Me