Build a Macro that can go online and export a data file to excel?

**WillyBanks** · 07-06-2013, 10:23 PM

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

**abousetta** · 07-06-2013, 10:42 PM

Hello and welcome to the forum,

Can you use the macro recorder, perform the standard tasks that you normally would do and then post the resulting code? Also it would be helpful to know the site URL.

abousetta

**WillyBanks** · 07-06-2013, 10:49 PM

Thanks for the fast reply abousetta. The URL is a secure company site. The steps are not the problem with the recorded macro, the problem is the export functioning. Have you ever seen this done?
Thank you!
Willy

**abousetta** · 07-06-2013, 10:52 PM

Do you mean you click on a button or other hyperlink on a webpage and it opens an excel file on your computer?

**WillyBanks** · 07-06-2013, 10:53 PM

click a button on a webpage and it opens an excel file with the data requested in the query

**abousetta** · 07-06-2013, 10:58 PM

Would something like this work for you? You would need to know the URLs in advance though. Also there is this tutorial using a different approach.

abousetta