I open many files from a workbook template. When they are first opened they are not saved. I want a way to show in a cell if the workbook is or is not saved at any particular time then if it is, to show the path of the file (maybe using =INFO("directory") and a function to get the file name. If the file is not saved initially, this function shows as my default file location. Is this possible? Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Determining if the workbook is saved
- Thread starter derekpegg
- Start date
Zack Barresse
MrExcel MVP
- Joined
- Dec 9, 2003
- Messages
- 10,881
- Office Version
- 365
- 2010
- Platform
- Windows
- Mobile
- Web
Via VBA, check the file name for ".xls". If a file is not saved it will not have an extension yet. For a current save, check the workbook.Saved property.
HTH
HTH
Upvote
0
Similar threads
- Solved
