View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default 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