I've got a workbook that is going to be managing revisions of other files. One of the buttons I have will be "Save *book* as a revision"
All revisions will be stored in the same directory. Each file will be named like:
Book Rev 1.xlsm
Book Rev 2.xlsm
Book Rev 3.xlsm
I'd like the book to be able to detect what the latest revision has been (in this case 3) and then assign the next number (Rev 4).
I could use a counter to see how many time the program has been called, but I'd much rather the program be able to read directories in case a user manually makes changes to the folder. Is this possible?
Bookmarks