How to Rename my Active Workbook before Saving Excel VBA?

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

THANKS A LOT

0 Replies