ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   pulling properties (https://www.excelbanter.com/excel-programming/406475-re-pulling-properties.html)

greg

pulling properties
 
strange,
how does windows do this if its not on the machine by default?



"Chip Pearson" wrote in message
...
Greg,

These properties are called Built-In Document Properties and can be read
with VBA in a open workbook with the BuiltInDocumentProperties collection.
There is a DLL file called the DSO OLE Document Properties Reader 2.1
available for download from Microsoft that allows you to get these
properties (and the user-defined Custom Document Properties) from close
files. All Office files (Word, PowerPoint, etc) support many of the
built-in document properties.

For a lot more information about document properties, see
http://www.cpearson.com/Excel/DocProp.aspx .



"greg" wrote in message
...
Excel has properties it stores.
keyword, author, comments, etc.........
In windows explorer you can see these properties.
How does it do that without opening the file?
Can you read these files without opening the files?
Can you read custom properties, without opening the file?
thanks







All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com