Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Doorn, Netherlands
    Posts
    311
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Printing/Exporting Comments only (2003)

    I have a large workbook with plenty commented cells. For documentation I would like to print/export those comments to a file for later use in a Word document.. Does anybody has any idea?

    regards, Teun

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Printing/Exporting Comments only (2003)

    Chip Pearson has such a macro on hs website - page down to "Printing Comments To Word" if it doesn't pop right up.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing/Exporting Comments only (2003)

    A small VBA routine could be written to extract the cell comments. However, we would need a couple of questions answered first:

    1- Where do you want the extracted comments. They could be put down column A of a new worksheet that the VBA code creates, or they could be written to a .txt file.

    2- If you want them written to a .txt file, what do you want the file named, and what directory do you want it stored in?

    3- Do you want the cell address inserted with the comment to identify where the comment came from?

    4- Is there more than one worksheet in the workbook? If so, do you want the comments extracted from all sheets? If not, which one should the comments be extracted from. If so, do you want the worksheet name inserted along with the cell address to identify where the comment came from?
    Legare Coleman

  4. #4
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Doorn, Netherlands
    Posts
    311
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing/Exporting Comments only (2003)

    John,

    I tried it! Does just what I want. Thanks.
    Regards, Teun

  5. #5
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Doorn, Netherlands
    Posts
    311
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Printing/Exporting Comments only (2003)

    Legare,

    Thanks for your reply, but Chip Pearson's code mentioned by John works fine for me.

    Regards, Teun

Posting Permissions

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