Outputto-Excel-Prevent Prompt to Save

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am writing a macro that I run with schedular to output a QUERY as an Excel
document. I want this to be automated and not prompt anyone about
overwriting the existing file

Thanks a mil
Elsa
 
Elsa,

As far as I know, the only way to do this via a macro is to remove the
existing file first. There are 2 ways to do this. You can make a
simple VBA Function in a standard module in your database, using the
Kill method, to delete the .xls file in question, and then use a RunCode
action in your macro to run this function. Or you could make a sumple
..bat file to issue a Del command to delete the .xls file, and then use a
RunApp action in your macro to run the batch file.
 
Back
Top