Save a the same workbook but add a variable number at the end

[swade730]

HI, I want to save down a template as the same named file. each time I save it I want to save it with an incremental variable number\

example
"myworkbook ver 1"
"myworkbook ver 2"

This is what I'm trying to leverage and build on but I am stuck...

this just keeps adding .xlsx to the same file, not different versions

Please Login or Register  to view this content.

Please Help

[rkey]

Hi Swade,

I usually append this to my filename:

Please Login or Register  to view this content.

Does that suit your needs?
Regards,
Rick

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[skywriter]

My code assumes you have a file named something like this.
C:\MyFolder\MyFileRev1.xls

Fpath returns the full path seen above.

My code initially looks for "Rev" in fpath

If you had a brand new file that didn't have Rev in the path you could check for that and name it Rev1 and bypass the rest of the code.

Then the newName line concatenates the 2 onto the original file name on the first loop. Dir checks if the file exists. With Dir if the file exists already it will return the file name, otherwise it returns "". So by checkingfor "" we confirm the file doesn't exist. revNumber will just keep changing until it finds the first rev number file that doesn't exist and once it does it saves the file and exits the loop.

Please Login or Register  to view this content.

[swade730]

Maybe:

Please Login or Register  to view this content.

The below Line confuses me it is making file2 value as "." in the Locals window

Please Login or Register  to view this content.

[swade730]

Hi Swade,

I usually append this to my filename:

Please Login or Register  to view this content.

Where would I insert this?

[JOHN H. DAVIS]

My mistake. Should be:

Please Login or Register  to view this content.

[swade730]

My mistake. Should be:

Please Login or Register  to view this content.

No worries, Marking this Thread as solved