Excel iconVBA icon

Couldn't Stand The Weather

storm cloud

World Weather Online has an API for requesting local and marine weather.

Continue Reading: Couldn't Stand The Weather »

Automation iconVBA icon

State Weather Advisories available by RSS

weather

In Exploring the NOAA API I posted code for consuming the NOAA RSS feed for Atlantic storms.

I also posted weather-finding functions using the Geonames API, the WebserviceX.NET API and even a cheap formula for opening weather.com.

Continue Reading: State Weather Advisories available by RSS »

Excel iconVBA icon

Got weather?

Hot on the heels of my update to the Latitude/Longitude functions page, I've written some more VBA code that uses web APIs to retrieve weather information for any zip code in the U.S.A. If you visit that page and then look at the code below, you may notice the similarity.

Continue Reading: Got weather? »

Excel icon

Weather formula

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?

Site last updated: February 9, 2012