Forum Discussion
semiro1815
Oct 04, 2022Brass Contributor
How to Rename my Active Workbook before Saving Excel VBA?
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
No RepliesBe the first to reply