web query
web query
(OP)
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,
"www.~~~~Aeropuerto/03-1999/84820.htm"
"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.
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,
"www.~~~~Aeropuerto/03-1999/84820.htm"
"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.





RE: web query
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: Eng-Tips.com Forum Policies before posting
Steam Engine enthusiasts
Steam Engine Prints
RE: web query
Thanks for that suggestion. I'll check that out right now.
Thanks
http://virtualpipeline.spaces.msn.com