How to Rename my Active Workbook before Saving Excel VBA?

Brass Contributor

The Idea:
So if other users change the workbook name, i need a macro that when someone later hits save, it will change/rename workbook name to a specific name or to that first previous one.

And if used a filepath in code, if possible with the current path.


The whole point:
Same Workbook - Current Path - Rename (if wb name changed) - Save.


(If wb name is different than "name", than rename to "name2" and Save).

Is it possible?

It would help me a lot and SAVE MY DAY


0 Replies