several ways
you could use the
Kill
command to kill the file first
and then save it so that there is no file by that name
you will get an error on the Kill command if the file does not exist, but
you can use
On error resume next
to skip the error. Look up in help index on the KILL method.
Warning. This will permantly delete any file you use it on without asking,
and can delete entire folders!

"Centurion" wrote:

Hello,
I am using Excel 97, and have written (by recording keystrokes)
a macro that does several things and finishes off by saving the file.
However if the saved file already exists it stops the macro and prompts
user if it's ok to overwrite the file.

I would like to........

1) how do I test (within VBA) to see if the file exists.

2) If the file does exist, then overwrite without prompt.
Or alternately, save file and incrementally add '1'
to the end of the subsequent file.

Example
File-01
File-02
File-03


Thanks in anticipation.

--
Centurion