View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Importing web data to Excel 2003

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

But have you tried DataImport External DataNew 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

On Sun, 6 Dec 2009 17:15:01 -0800, JohnB
wrote:

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....ore-obs/fd.cgi

Any help would be appreciated.

thanks