Trying to set parameters on website for Excel download. 1

[Mightyginger]

Hi guys,

Do basically on this website there is some data I'd like to be able to download.

http://www.oenb.at/isaweb/report.do?lang=EN&report=1.2.1

At the bottom of the page are some parameters you can set for the time interval over which you'd like the data. Looking at the link at the top to the Excel download (which is my preferred method) then I thought I could just manipulate the download string which is

http://www.oenb.at/isaweb/reportExc...n=2006&tjBis=2012&tmVon=01&tmBis=01ttVon=01&t

where Von means the start and Bis the end. But it seems when I simply submit this query that it just gives me what I last selected on the website. So I think I somehow need to set the parameters on the form, submit the form, then download the file. Any thoughts please?

Many many thanks in advance.

 

[MazeWorX]

take a look here. This is not simply a matter of changing the url

http://www.tushar-mehta.com/publish...ba_web_pages_services/index.htm#_Toc173749365

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work" <<Edison>>

 

[Gruuuu]

Star for Maze, I had not thought of using an XMLHttp request in VBA! I'd always just accessed IE's Document Object Model and manipulated it that way.