Posts tagged with 'API', page 3 of 4

FlightCaster API examples in VBA

May 28, 2010 by JP

FlightCaster is a web application that offers information on flight delays. According to FlightCaster,

FlightCaster predicts flight delays. We use an advanced algorithm that scours data on every domestic flight for the past 10-years and matches it to real-time conditions.

That means you can use their site to guess if your flight (or that of your loved ones) is going to be on time. Here's a colorful sample. You can also check on airport weather and ground delays imposed by the FAA.

Filed Under: Excel, VBA

Tagged With: API, MSXML2, XMLHTTP

Geonames API puts geographical data at your fingertips

May 21, 2010 by JP

1 Comment(s)

globe

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.

Filed Under: VBA

Tagged With: API, geonames, MSXML2, XMLHTTP

Looking up Australian postal codes

April 7, 2010 by JP

Comments

If you live in Australia, you'll need to know the post code for your letters, bills and postcards. Here's some VBA code and a sample app that can help you look up post codes in Australia.

Filed Under: VBA

Tagged With: API, MSXML2, XMLHTTP

Got weather?

March 15, 2010 by JP

Comments

umbrella

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.

Filed Under: Excel, VBA

Tagged With: API, MSXML2, weather, XMLHTTP

Open or print files in VBA

February 17, 2010 by JP

10 Comment(s)

I've previously posted code for opening any email attachment. See Open Any Email Attachment From Outlook. Note that this technique works for any file and in any VBA environment; they don't have to be email attachments for you to open them.

But you can open OR print any file using the ShellExecute API, and it also works anywhere. The following function can do this.

Filed Under: VBA

Tagged With: API, print, ShellExecute