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

Bob

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)



On Wed, 21 Oct 2009 15:46:45 -0400, "Robert Flanagan"
wrote:

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

Bob

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

Bob

"Chip Pearson" wrote in message
...
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)



On Wed, 21 Oct 2009 15:46:45 -0400, "Robert Flanagan"
wrote:

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

Bob