Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
BuiltInDocumentProperties...some no workee
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
BuiltInDocumentProperties...some no workee
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
BuiltInDocumentProperties...some no workee
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
BuiltInDocumentProperties...some no workee
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 "CLR" ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
BuiltInDocumentProperties...some no workee
COOL.....that helped a heap.
Thank you much, kind Sir! Vaya con Dios, Chuck, CABGx3 "NickHK" wrote: 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 "CLR" ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Syntax to address ThisWorkbook.BuiltinDocumentProperties via Access Automation? | Excel Discussion (Misc queries) | |||
BuiltInDocumentProperties | Excel Programming | |||
BuiltinDocumentProperties | Excel Programming |