Retrieving Data from an IE window?

[BrooksR]

How can I retrieve the data/text that is displayed in an IE window?

I do use URLDownloadToFile for most webpages, but a few pages download the source code not the data being displayed.

Any ideas appreciated.

 

[terzaghi]

whit excel 2000 try this:

1. new sheet
2. Data -> Get External Data -> New Web Query
3. Select the web page you want to import in excel
4. select the cell you want to start the retrived page
5. Done!

6. if you want to refresh the data right click on the part of the page and then Reftesh data on the bottom.

Hope this helps

Andrea

 

[BrooksR]

Thanks for the idea, Andrea. When I tried it, Excel said 'the query returned no data'. Eventually, I need to automate this in VB/Access. Any other thoughts?

Brooks