Results 1 to 3 of 3

Thread: Comments property of a .xls file

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Feb 2000
    Posts
    21
    I am trying to get the "COMMENTS" property of a file. I mean, I am looking for the value which is displayed in the "Comments" textbox when you right-click on a file, ask for its properties and select the "Summary" tab.

    I know there is a way to do it with the VBScript FSOs but I would prefer using an API.

    Thanks in advance,

    Tipi

  2. #2
    Addicted Member
    Join Date
    Jan 2000
    Location
    Fresno, California, USA
    Posts
    195
    You can get to it by accessing the worksheet.comments collection. Just loop through it and access each comment. If you need code, let me know.

  3. #3

    Thread Starter
    Junior Member
    Join Date
    Feb 2000
    Posts
    21
    If will not be suitable in my case. I am in VB when I want to access the comments and I do not want to use Excel classes.

    In fact, I would like to be able to retrieve the comments properties from any file (.xls, .doc, .rpt) without having to open it...

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width