Getting File property info with code?

[debartsa]

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

 

[Ulrik Gustafsson]

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/defaul...port/kb/articles/Q224/3/51.asp&NoWebContent=1

HTH
/Ulrik

 

[debartsa]

Thanks for your help Ulrik!

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.aspx?scid=http://support.microsoft.com:
80/support/kb/articles/Q224/3/51.asp&NoWebContent=1

HTH
/Ulrik



menu;