returning comments propery of a closed file

  • Thread starter Thread starter Robert Flanagan
  • Start date Start date
R

Robert Flanagan

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)
 
Back
Top