Hello
I am looking for code that would save a copy of the excel file in a designated folder
say there are two folders
Desktop/Current
Desktop/FinArchive
Say the file is called AccountsP1W1.xlsm, when a button within the file is pressed the file will then save a copy with the word archive added to the end of itself in FinArchive folder called AccountsP1W1archive.xlsm
The button would be in the SETUP tab
Ideally a confirmation pop up (any any kind of confirmation) that the operation is completed successfully would be handy but not essential, or that
Bookmarks