Dynamic website as a target for QueryTable

[atlquaker]

I am trying to create a dynamic QueryTable connection. The site I am using displays a table of data as well as some filters. Everytime you change the filter, the webpage reloads with different data. I need to import these various data tables into Excel. How can I automate this via VBA? I know how to set up a QueryTables via VBA... and I know how to post parameters to a website via the Navigate() function... but I need a something that is a combination of the two... I hope this is clear. If not, below is a written example of what I am trying to do:


1. Submit parameters to website
2. Take response and import data to worksheet
3. Submit another parameter to website
4. Take response and import data to worksheet...

 

[John_w]

A web query may work if the parameters appear in the URL (query string) - it's just a matter of constructing the URL with the required parameters. Otherwise use IE automation and the HTML object library to manipulate the web site and retrieve the data.

 

[atlquaker]

John,
Unfortunately the web form only accepts post parameters, so I can't dynamically change the URL. So, what is the best way to get the data out of the page and into Excel? Parse the HTML for the table I need? Luckily, all of the data I need is in a table that has an ID. What is the best way to get a table and put it into Excel?

 

[John_w]

Search for getonetable, e.g. http://www.mrexcel.com/forum/showthread.php?t=408803&highlight=getonetable

 

[atlquaker]

John, this worked perfectly. Thanks for your help.