View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
greg greg is offline
external usenet poster
 
Posts: 108
Default 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