You are here: Home » Excel » Weather formula

Weather formula

calendar date March 2, 2009 by · 100 words · Leave a Comment comment link

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?

Related Articles:

categories Filed Under: Excel · tags Tagged With: ,
About JP

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 to learn more about VBA. Keep Reading »

Share This Article:

Share and bookmark this articledelicious buttonfacebook buttonlinkedin buttonstumbleupon buttontwitter button
Note: Comments are subject to the Blog Comment Policy and may not appear immediately. To post VBA code in your comment, use code tags like this: [vb]your code goes here[/vb]

Add a Comment:

*

Site last updated: February 3, 2012