Answered my own question!! For anyone else with the same problem please use
the following link:

http://www.contextures.com/xlcomments03.html#CopyToWord


"Jas" wrote:

Hi - Im just wondering if it is possible to export comments made on a cell to
an excel document? If so, how would I do this?

Thanks in advance,
Jas