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
Bookmarks