If Filename exists... then

[mfusfw]

Good Afternoon All.

I currently have the below code being used to save a file

Please Login or Register  to view this content.

And would like to update it so that if the filename exists already then to append the name to then be like a "-1", "-2" or something like that... even if only on those files it included the Format(Now(), "yyyy-mm-dd hh-mm-ss") stamp... how would I incorporate this?

[TMS]

You could use Dir to check for the filename you want to use. If it exists, add the suffix. Loop until it doesn't exist.

[mfusfw]

How would I code that?

[mfusfw]

I have tried the following code but am running into an issue where it is not seeing the file name exists in the directory.

Please Login or Register  to view this content.

[Artik]

eg.

Please Login or Register  to view this content.

Artik