returning comments propery of a closed file

[Robert Flanagan]

Is there a way to return the comments property of a closed workbook?
(Without opening it)

Bob

 

[Chip Pearson]

See http://www.cpearson.com/excel/DocProp.aspx for code details and a
required DLL available from Microsoft. Once you have downloaded and
installed the DLL from MS, download
http://www.cpearson.com/Zips/modDocumentProperties.zip from my DocProp
page. Using that code, you can then do something like


Sub AAA()
Dim CommentString As String
CommentString = ReadPropertyFromClosedFile("C:\Book1.xls", _
"Comments", PropertyLocationBuiltIn)
Debug.Print CommentString
End Sub

See the DocProp page for full documentation and examples.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2010
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Robert Flanagan]

Many thanks. Now to find the time to write the code....

Bob