Need to overwrite existing file on output to file

[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

 

[Jim/Chris]

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

Kill "c:\YourPath\YourFile.xls"

Jim