searching folder for existing file

Here's another one:
I need to check if a file already exists in a folder, and prompt the user to choose if they want to overwrite it.

I've found some posts that dal with getting filenames, but haven't found one that addresses this.

Thanks again!
Ted

Please Login or Register  to view this content.

Mudraker:
(just getting back to this....)

This code works EXCEPT when the file already exists in the folder. I'd like be able to choose not to overwrite the file without it kicking me out of the macro.

This was my attempted solution, but it didn't work. I'm still getting the "regular" saveas dialog prompt. Is there anyway to skip this? I didn't see anything in the help file about using true/false....

Ted

Please Login or Register  to view this content.