Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Write worksheet comments to text file


posted by Nick Hodge
Thu, Jan 24 2008

Downloads: 30
File size: 35.5kB
Views: 277
Write worksheet comments to text file
Filed under: , ,

This file uses the VBA output routines to take comments in a workbook and write them out to a text file. It appends in the text file the sheet and address from whence they came. There is also a routine to copy comments in one sheet to the same cells in another.

Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.