How to request web data via macro from excel

[ivymike]

I'd like to set up a macro to periodically query a web site and capture particular pieces of the returned information. Does anyone know how I can make excel go to a URL (as though I'd clicked a link) and capture the data that's returned?

 

[wlhijlke]

Hi,

Try ADO in your code then you can connect to a url. To use ADO see the MSAccess help files for futher information.

P.S.
I'm still learning how to use ADO so I can't give you examples for your problem, but I know it's possible!

Good luck.