Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All........
I am trying to use this code but on some files I get a VB error on the "Last Save Time" line........how may I cause a return of "Not available" instead of the VB error? Sub GetProps() MsgBox ActiveWorkbook.BuiltinDocumentProperties.Item("Aut hor") MsgBox ActiveWorkbook.BuiltinDocumentProperties.Item("Las t Save Time") End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Syntax to address ThisWorkbook.BuiltinDocumentProperties via Access Automation? | Excel Discussion (Misc queries) | |||
BuiltinDocumentProperties | Excel Programming |