web query 1

[BigInch]

HI,

I need to download historic meterological data from a web table to Excel. I can query the table and download one month, but 32 rows down I then need to change the web page to the next year and download the new data.

The URL changes name between pages like this,
"

http://www.~~~~Aeropuerto/03-1999/84820.htm"

"

http://www.~~~~Aeropuerto/03-2000/84820.htm"

Is there some way to automatically grab a query, edit it to a new year and "paste" it a certain number of rows down?

I haven't found it yet and my ctrl-ins fingers are worn down to the bone. Any help on this is greatly appreciated.

http://virtualpipeline.spaces.msn.com

 

[johnwm]

Look at using VBA and the Microsoft Internet Transfer Control (it's in Windows/system32/msinet.ocx)
Very versatile, can handle HTTP and FTP requests. There are some examples of use at

http://officeone.mvps.org/vba.html

in the Office VBA section


Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting
Steam Engine enthusiasts
Steam Engine Prints

 

[BigInch]

John,

Thanks for that suggestion. I'll check that out right now.

Thanks

http://virtualpipeline.spaces.msn.com