I am working with a lot of online databases with which I have to go online, pull data and use the online export to excel function. Is there a way to build a macro to do this?

This isn't pulling data from a webpage with XML format tables that can be imported using a web query; it is a webpage which has my query listed and allows me to export to excel. Running the query online and then export results to excel is the action I want the macro to perform.

Thanks for any guidance!
Willy