Outputto-Excel-Prevent Prompt to Save

[Printing of Range Name References]

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

 

[Steve Schapel]

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.

 

[Printing of Range Name References]

Thanks Steve

I know a bit of VB, so I hope I'll figure it out