Hi,

I have a code to save an Excel sheet into a specific name to a drive. Then
if the file exists, my code prompts the user to overwrite the existing file
or to create a new file. When the user chooses to create a new file, I want
the new files increment by 1 (e.g. test1.xls, test2.xls, etc.).

Can someone help me with the code to create those new files by incrementing
1? Can you also limit the new file up to 10 (e.g. test10.xls)? Then prompt
the user with a message that you have exceeded the limit.

Please help.

Thanks.