Weather formula
March 2, 2009 • JP • No Comments • Rate This Article
• Links to this article
File this one under 'cheap amusement': The following hyperlink, placed in an Excel worksheet, opens Internet Explorer and sends you to weather.com for the zip code placed in A1:
=HYPERLINK("http://www.weather.com/weather/local/"&A1&"?lswe="&A1&"&lwsa=WeatherLocalUndeclared&from=searchbox_localwx","Weather Check")
Sorry folks, US zip codes only.
Could a XML-based weather add-in be far behind?
Excel ·
Rate This Article:
(No Ratings Yet)
Loading ...What now?
Subscribe To The Blog
Email This Article
Follow Me On Twitter
My Facebook Page
Or just keep reading:
I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space if you want to learn more about VBA. Keep Reading »
Previous Post: Extract distribution list members to Excel
Next Post: Why I prefer late bound code
Speak Your Mind
Tell us what you're thinking...Certain comments (including first-time comments) are subject to moderation and will not appear immediately. Please view the Comment Policy for more information. To post VBA code in your comment, use tags like this: [cc lang='vb']Code goes here[/cc].