Export multiple queries via Macro

[Access Beginner]

Hi guys,

I have 15 queries which I have to export to excel. I have gone to the Macro section in Access and used the "OutputTo" action. But from my limited understanding the Excel file that you export to must already exist in the directory your are importing to.

My intention is to create 15 Macros to export each query (these are 15 different Area queries), and then create another macro( called for example Area Exports),to run the above 15 Area Macros but the message of "file already exists" will pop up. I want to be able to run the Area Exports macro and not have the file already exists message show and then having to hit OK for each instance.

Is this possible?

Cheers

 

[Access Beginner]

Hi guys,

I have 15 queries which I have to export to excel. I have gone to the Macro section in Access and used the "OutputTo" action. But from my limited understanding the Excel file that you export to must already exist in the directory your are importing to.

My intention is to create 15 Macros to export each query (these are 15 different Area queries), and then create another macro( called for example Area Exports),to run the above 15 Area Macros but the message of "file already exists" will pop up. I want to be able to run the Area Exports macro and not have the file already exists message show and then having to hit OK for each instance.

Is this possible?


Cheers

Sorry forgot to mention I am using Access 2007

 

[SydneyGeek]

If you hit OK, I assume that the export then runs.
You can avoid the warnings by putting SetWarnings (No) step before the exports, then SetWarnings (Yes) once finished.

Denis

 

[Access Beginner]

Thanks Denis,

That does the trick.

Cheers
Haydn