Geonames is a geographical database with web services that let you extract useful information about different places, such as weather, timezone and post codes. This information may be extracted programmatically for use in your VBA programs.
Your Mashup not listed on ProgrammableWeb yet? Tell us about it and get listed.
Using bit.lt in VBA
Geonames geographical data API
Ruby Library for Geonames
Python Geocoding Aggregator
APIs, mashups and code. Because the world's your programmable oyster.
Executive Editor, ProgrammableWeb. Author, Map Scripting 101. Lover, APIs.