Need to overwrite existing file on output to file

  • Thread starter Thread starter damsel
  • Start date Start date
D

damsel

Hi!
I have a report that is generated from a macro and now I need to set i
up to run automatically. The problem is that currently there is
dialogue box that pops up asking if I want to over-write the existin
file and I can't seem to suppress that. Is there a way to either:

Suppress the dialogue and automatically overwrite the file

or

Delete the file first, so that I don't get the message.

Thanks
 
You can always use the Kill statement before you do the
export to delete the old file.

Kill "c:\YourPath\YourFile.xls"

Jim
 
Back
Top