Hi Nick..........
Thanks for the response. I think the DSO thing is a little beyond me right
now. I mainly just need to identify the filesize of the open workbook at
this time. I'm making a LogSheet that records each time the file is opened,
by whom, etc, and I would like to include the current filesize each time if
possible.

Vaya con Dios,
Chuck, CABGx3



"NickHK" wrote:

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/d...DisplayLang=en

NickHK

"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