Getting File property info with code?
 

Hi Everybody!

Does anyone know if a property or function exists within the Excel 97 Object
Model to retrieve file property info? i.e. from Windows explorer if you
right-click an (excel) file and select "properties" from the pop-up menu; a
window appears with a bunch of tabs. I'm interested in the "Summary" tab in
particular to interrogate properties such as "Author", "Title", "Subject",
etc...

Thanks for any help!
Sam

Getting File property info with code?
 

Hi,

You can retrieve these properties in an opened workbook by using the
BuiltinDocumentProperties property of the Workbook object.
See BuiltinDocumentProperties Property in the help file for more info.

If you want to retrieve these properties from a closed workbook you need a
dll from Microsoft - DSO file.
This is the only way to access these properties from a closed file.
It is available for download - please see this link.

http://support.microsoft.com/default...NoWebContent=1

HTH
/Ulrik



"debartsa" wrote in message
...
Hi Everybody!

Does anyone know if a property or function exists within the Excel 97
Object
Model to retrieve file property info? i.e. from Windows explorer if you
right-click an (excel) file and select "properties" from the pop-up menu;
a
window appears with a bunch of tabs. I'm interested in the "Summary" tab
in
particular to interrogate properties such as "Author", "Title", "Subject",
etc...

Thanks for any help!
Sam

Getting File property info with code?
 

Thanks for your help Ulrik!


"Ulrik Gustafsson" wrote in message
...
Hi,

You can retrieve these properties in an opened workbook by using the
BuiltinDocumentProperties property of the Workbook object.
See BuiltinDocumentProperties Property in the help file for more info.

If you want to retrieve these properties from a closed workbook you need
a
dll from Microsoft - DSO file.
This is the only way to access these properties from a closed file.
It is available for download - please see this link.


http://support.microsoft.com/default...microsoft.com:
80/support/kb/articles/Q224/3/51.asp&NoWebContent=1

HTH
/Ulrik



"debartsa" wrote in message
...
Hi Everybody!

Does anyone know if a property or function exists within the Excel 97
Object
Model to retrieve file property info? i.e. from Windows explorer if you
right-click an (excel) file and select "properties" from the pop-up
menu;
a
window appears with a bunch of tabs. I'm interested in the "Summary" tab
in
particular to interrogate properties such as "Author", "Title",
"Subject",
etc...

Thanks for any help!
Sam