Solved: BuiltinDocumentProperties - Closed Workbook

[johnske]

Has anyone got a procedure (an API maybe) to get the BuiltinDocumentProperties("Comments") of closed workbooks without opening them?

TIA,
John :)

[Bob Phillips]

John,

See this earlier post http://www.vbaexpress.com/forum/showthread.php?t=6827&highlight=DSOFile which uses DSO to get them.

[johnske]

Thanks Bob. :) (thought I'd seen something like that before but just couldn't find it)