VBA Code to NOT Overwrite file

[wolfdemon710]

Hi,

I was wondering if there is way not to override existing file in the folder.

For example if I have a file named "Test", I don't want the vba code to overwrite the file but save it as "Test(1)"

Please Login or Register  to view this content.

I am saving it using above code. Any help?

[xladept]

Hi Wolf,

Try this:

Please Login or Register  to view this content.

[shg]

Maybe ...

Please Login or Register  to view this content.

[skywriter]

Another possibility.

Please Login or Register  to view this content.