BuiltInDocumentProperties...some no workee

[CLR]

Hi All........
In Excel 97SR2, I'm having trouble bringing up some of the items in the
BuiltInDocumentProperties collection....specifically, "Last Print Date",
"Last Save Time", "Total Editing Time", and "Number of Bytes". Is this
ordinary? Are there any workarounds for any of these items?

TIA
Vaya con Dios,
Chuck, CABGx3

 

[NickHK]

Yes, with Excel 2000 I get errors on "Last Print Date", "Total Editing Time"
and some others. (But "LastSaveTime" works and "Last Print Date" may fail
because the file has never been printed, not sure.)
IIRC, those properties are Office wide and not all applied to every app.
Obviously "Number of words", "Number of lines", "Number of paragraphs",
"Number of slides" etc, do not make much sense in an Excel environment,
although "Total editing time" does.

You may try the DSO way on the closed file to see you get any different
results.
http://www.microsoft.com/downloads/...c6-520b-4a0a-878a-53ec8300c4c2&DisplayLang=en

NickHK

 

[CLR]

COOL.....that helped a heap.

Thank you much, kind Sir!

Vaya con Dios,
Chuck, CABGx3