Hello
Looking for code to rename current file according to new information entered in specific cell
say the file AccountsP9W1.xlsm has new information entered in the tab called SETUP under D8 and D9 . New entries D8 =10 and D8=2
When the button is clicked to run the code, it renames the file to AccountsP10W2.Xlsm
I figure that it is not possible to rename an open file, would the code close and then reopen the file with the new name?
Ideally the button would be in the SETUP tab as well
Thanks
Bookmarks