Document Properties

[LadyDi]

Is there a formula that I can enter that will tell me the properties of any document (i.e. author, title, subject), not necessarily the one that is opened?

 

[HaHoBe]

Hi, LadyDi,

I don´t know about a formula (this formula should utilize Excel4Macros in Names like Cell) as I usually use BuiltinDocumentProperties or CreateObject(Class:="Shell.Application") in VBA to get the information.

Ciao,
Holger

 

[LadyDi]

This sounds like just what I need. Could you please give me more direction on how to utilize this? If I put the document name in cell A1, what do I need to do to get the document properties to appear in cell B1?