BuiltInDocumentProperties...some no workee

[Guest]

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

 

[Guest]

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]

OK, I thought you could do that with a worksheet formula; one of the Info(),
Cell() or macro4 GET calls, but I can't find anything now.
However, it's easy enough to write your own ;

Public Function GetMyFileSize() As Long
GetMyFileSize = FileLen(ThisWorkbook.FullName)
End Function

then call it from the a cell or use in your VBA code.

NickHK

 

[Guest]

COOL.....that helped a heap.

Thank you much, kind Sir!

Vaya con Dios,
Chuck, CABGx3