Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
loop through code and refernce text file for info | Excel Discussion (Misc queries) | |||
Windows Visible Property - Code Help | Excel Discussion (Misc queries) | |||
VBA Code For OR-Function Using Cell Property | Excel Discussion (Misc queries) | |||
BackColor property code | Excel Programming | |||
Inefficient VBA Code - Worksheets Property | Excel Programming |