Using VBA you 2 options:
- Open the WB and use
ThisWorkbook.BuiltinDocumentProperties
ThisWorkbook.CustomDocumentProperties

- Use something like DSO
http://www.microsoft.com/downloads/d...DisplayLang=en

If you are looking for WS names, you could maybe use ADO/ADOX to get inof on
the "database" structure.

NickHK

"JVLin" wrote in message
...
Hi,

is it possible to change/add properties on the 'Custom' tab using VBA?
(I've
tried to use the VB recorder, but it comes up empty.)

Similary, is it possible to read from the 'Contents' properties tab using
VBA, e.g. the names of worksheets or named ranges?

Context:
I'm still not satisfied with the speed at which I get certain basic info
from an Excel file and I was hoping that by writing such info to the
file's
properties and reading them without opening the workbook I might speed
things
up.

Many thanks for your help on this.

Regards,
JVL