Printing/Exporting Comments only (2003)

[Teunis]

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

[JohnBF]

Chip Pearson has such a macro on hs website - page down to "Printing Comments To Word" if it doesn't pop right up.

[LegareColeman]

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?

[Teunis]

John,

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

[Teunis]

Legare,

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

Regards, Teun