Export cell comment as a data cell

[KADL]

I am importing Excel data into an Access database. Is it possible to put
cell comments into a column of their own? I need both the field data and the
comments.

Thanks!

 

[FSt1]

hi
see debra dalgleish's site - copy comment to adjacent cell.
http://www.contextures.com/xlcomments03.html#CopyAdjacent

regards
FSt1

 

[Gord Dibben]

You can use this macro found at Debra Dalgleish's site to extract the comments'
contents to an adjacent column.

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


Gord Dibben MS Excel MVP