| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
test for new, unsaved workbook
I want to test whether a workbook is a brand-new/never-been-saved, i.e.,
"Book 1." I notice that such books do not have a path yet. Is that a good test? E.g., If ActiveWorkbook path = "" then ' it's never-been-saved Doug |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
test for new, unsaved workbook
does this help?
If ActiveWorkbook.Saved Then 'do something else 'do soemthing else end if -- Gary "Doug Glancy" wrote in message ... I want to test whether a workbook is a brand-new/never-been-saved, i.e., "Book 1." I notice that such books do not have a path yet. Is that a good test? E.g., If ActiveWorkbook path = "" then ' it's never-been-saved Doug |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
test for new, unsaved workbook
Gary,
No, because if I open a brand new workbook this is what I get in the immediate window: ? workbooks("Book6").Saved True Since I'm only trying to test for brand-new, never-been-save workbooks, that won't work, because it doesn't distinguish from a workbook that's been just saved. Thanks, Doug "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... does this help? If ActiveWorkbook.Saved Then 'do something else 'do soemthing else end if -- Gary "Doug Glancy" wrote in message ... I want to test whether a workbook is a brand-new/never-been-saved, i.e., "Book 1." I notice that such books do not have a path yet. Is that a good test? E.g., If ActiveWorkbook path = "" then ' it's never-been-saved Doug |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
test for new, unsaved workbook
Hi Doug,
Your If ActiveWorkbook path = "" then test is fine. --- Regards, Norman "Doug Glancy" wrote in message ... I want to test whether a workbook is a brand-new/never-been-saved, i.e., "Book 1." I notice that such books do not have a path yet. Is that a good test? E.g., If ActiveWorkbook path = "" then ' it's never-been-saved Doug |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
test for new, unsaved workbook
Thanks Norman.
-- Doug "Norman Jones" wrote in message ... Hi Doug, Your If ActiveWorkbook path = "" then test is fine. --- Regards, Norman "Doug Glancy" wrote in message ... I want to test whether a workbook is a brand-new/never-been-saved, i.e., "Book 1." I notice that such books do not have a path yet. Is that a good test? E.g., If ActiveWorkbook path = "" then ' it's never-been-saved Doug |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shared Workbook User had unsaved information disappear | Excel Worksheet Functions | |||
| How to recover unsaved workbook? | Excel Discussion (Misc queries) | |||
| Change the name of an unsaved workbook? | Excel Programming | |||
| How to reference unsaved workbook in functions???? | Excel Programming | |||
| Closing an Unsaved (but Changed) Workbook | Excel Programming | |||
Linear Mode
