Extract Comment into a cell

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have a large, sloppy spreadsheet that I want to export
to tsv, and inport into Access for an intranet project.

Is there any way to build a macro, or other formula that
can take the comments associated with a paticular cell,
and place it in another (hopefully concentating it's
contents to the comment) so that these comments can be
imported into a "notes" field in Access?

I have no experience with macros, but if the answer lies
within, I think I can pick it up.

I did export a web page, and managed to parse the xml code
out of the comments, leaving only the comment id, and the
comment itself, but I was hoping there was another way,
because during the transition period from this sheet to
the DB, I may have to do this a couple of times.
 
Back
Top