exporting query data to excel

  • Thread starter Thread starter adullam04-excelgoogle
  • Start date 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?
 
Back
Top