Importing web data to Excel 2003

[JohnB]

I have built a flight planning program for aviation using Excel 2003. I am
trying to find a function to import winds aloft from NavCanada's aviation
weather site, to avoid manual entries. Is there a web site where raw text
data from NavCanada's site to import, or a way to import it from their normal
web display?

Below there is a link to NavCanada's normal display of data.

http://www.flightplanning.navcanada.ca/cgi-bin/Fore-obs/fd.cgi

Any help would be appreciated.

thanks

 

[Gord Dibben]

I get an access denied on your URL................no permission.

But have you tried Data>Import External Data>New Web Query?

Enter a valid URL then click on the yellow arrows to select the data for
import to Excel.


Gord Dibben MS Excel MVP