| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Has file EVER been saved?
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Has file EVER been saved?
Hi,
If the workbook has never been saved, ThisWorkbook.Path will be empty. Hope this helps, JP On Oct 19, 5:20 pm, XP wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number Format on Excel File saved from .html file | Excel Discussion (Misc queries) | |||
| Saved *.csv file gives SYLK file type warning upon Excel 2003 open | Excel Discussion (Misc queries) | |||
| How to tell number of spaces between values in saved text file fromthe original xls file | Excel Discussion (Misc queries) | |||
| why is absolute hyperlink in XLS file changed when file is saved | Excel Discussion (Misc queries) | |||
| To get client data from a saved file back to the master file | Excel Discussion (Misc queries) | |||
Linear Mode
