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

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

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

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

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