exporting query data to excel

  • Thread starter adullam04-excelgoogle
  • Start date
A

adullam04-excelgoogle

I have an Excel file that I use to make charts. I use access queries
to generate data and then paste it into the excel file. When I
initiate a macro in Excel, it creates a new file an does all of its
magic to generate the desired product.

I want to automate this. With the click of a command button on access,
I want the query to export itself into this excel file and then run
that macro in Excel.

Is this possible? How would I go about that?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Embedded Excel into Word with Tables 0
Cell data entering slow! 0
VBA - exporting serial letters to single documents 0
Excel - Wich Function should I use? 1
Merging from an Excel file with graphics 1
Excel --> Word 4
Menu Macro Not Executing - Need Help 1

Top