Has file EVER been saved?

G

Guest

What is the best method for determining if the currently open file has EVER
been saved?

I know it would not be prudent to do so, but a user could potentially be in
an unsaved template named like "Test.xls" and when saved would look like
"Test.xls.xls" right?

If so, this invalidates looking for a period or xls in the file name to
determine its save status...believe me, a couple of my users are not beyond
this...

Thanks much for your assistance.
 
J

JP

Hi,

If the workbook has never been saved, ThisWorkbook.Path will be empty.


Hope this helps,
JP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Don't Show Msg Box if file ext is .xls 1
Determine if template file is dirty 1
Find filename of open file 5
Show if file has been saved 1
Determine whether the user has saved the file? 4
Check to see if excel file has been saved 2
Finding what has changed. 4
Lose macros before saving 4

Top