Exporting Excel Comments in to Access tables

  • Thread starter Thread starter Ian Millward
  • Start date Start date
I

Ian Millward

I want to combine several Excel spreadsheets into an Access DB. The
Spreadsheets have "Comments" dotted about all over the place. I want to copy
them into a single field which I would then like to export as an Access
"Memo" field. I am stuck on turning the Comments content into Text in the
Excel cell. I believe it is something to do with the Comments.Text being
both a property and a method. Anybody give me a hint?



Ian Millward

Edinburgh
 
Ian

Not sure I follow exactly what you are trying to do but in the activecell
you would use

Activecell.Comment.Text

This returns the text from the comment of that cell. If you want to recover
lots, then you will need to iterate through the range (psuedo code)

For each mycell in Range("A1:A100")
StringVariable=mycell.comment.text
'Do something with the value here
Next mycell

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top