Has anyone got a procedure (an API maybe) to get the BuiltinDocumentProperties("Comments") of closed workbooks without opening them?
TIA,
John
Has anyone got a procedure (an API maybe) to get the BuiltinDocumentProperties("Comments") of closed workbooks without opening them?
TIA,
John
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
John,
See this earlier post http://www.vbaexpress.com/forum/show...hlight=DSOFile which uses DSO to get them.
Thanks Bob. (thought I'd seen something like that before but just couldn't find it)
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.