Export Excel Comments to a Word Document

[alossie]

Hi,

Does anyone know how to export comments to a word document? I searched
the forum and tried to run an old Macro that someone had written.
However, I get syntax errors when I try to run it. They are not
specified.

Thanks,

Amy

 

[JE McGimpsey]

Does anyone know how to export comments to a word document? I searched
the forum and tried to run an old Macro that someone had written.
However, I get syntax errors when I try to run it. They are not
specified.

It would have been helpful to post the macro.

What do you mean by "they are not specified"? The VBE should highlight
syntax errors in red, and select the offending line when you choose
Debug/Compile.

Some newsgroup readers (especially web-based readers) insert
non-breaking space characters instead of spaces. When you paste them
into the VBE, it doesn't know how to interpret them. If that's the case,
deleting the white space at the beginning of each line and replacing it
with spaces or tabs should clear the syntax error(s).