Save file by incremental file name

[mainemojo]

I have workbooks that I use a "_v##" for versioning (yes, I know I can use version control, but in this instance, I can't). This is how I need to use this macro...

The opened file will have a name something like "2019-TestFile_v13.xlsx". When the macro runs, I would like for it to save it by automatically increment the _v portion. In this instance, it would need to save as "2019-TestFile_v14.xlsx". If "2019-TestFile_v14.xlsx" already exists, then it should try to save it as "2019-TestFile_v15.xlsx" and so forth until it is able to save it to a new file.

Keep in mind there may or may not be the previous files in the same directory (such as "2019-TestFile_v9.xlsx").

[CK76]

Just store in some out of way sheet/cell the incremental number. And use that in your variable.

Alternately... if all files are kept in same folder. You could use DIR() function to count # of files that match "2019-TestFile_v*.xlsx" pattern.

Though, 1st method is easier to maintain and less prone to error, if file(s) gets moved from target folder.

[WideBoyDixon]

This might do what you're after for the active workbook:

Please Login or Register  to view this content.

WBD

[mainemojo]

Thanks WideBoy!