How to request web data via macro from excel
How to request web data via macro from excel
(OP)
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?





RE: How to request web data via macro from excel
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.