pulling properties

[greg]

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

 

[Chip Pearson]

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]

thanks,
I will look into it.

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]

thannks i will take a look

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]

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

 

[KIM W]

In Windows Explorer I cannot see or find Excel Properties "Keywords",
"Category", or "Subject". I have spent a lot of time looking around in
Windows Explorer Search, including advanced options. I don't see it.
Excel 2007
Windows XP
Where is it? I would very much like to search a directory and find all the
spreadsheets with a certain keyword entered in properties. (Cheapo document
management!)

KIM

 

[greg]

If you go into a folder, then you right click on the "name" bar. then click
"more...."
you will see keywords.
But it does not always seem to show the right data in.

 

[KIM W]

Thanks for the reply. I don't understand the instructions. Could you be
more explicit? What is a "name" bar?

I have clicked around in Explorerer and Search for half an hour now (and
previously) and cannot find anything referring to search on keywords I enter
in a document''s properties.