I am in the process of converting a spreadsheet to an access database.
The sheets I am working with have several cell comments. I would
like to know how to access each comment of each sheet adn figure out
what sheet and cell it is in.

Thanks in advance
Kevin

Hi

Dave Peterson have a macro on this webpage that copy the comments in a Word file
http://www.contextures.com/xlcomments03.html#CopyToWord

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SirPoonga" wrote in message om...
I am in the process of converting a spreadsheet to an access database.
The sheets I am working with have several cell comments. I would
like to know how to access each comment of each sheet adn figure out
what sheet and cell it is in.

Thanks in advance
Kevin

Hi
as a starting point:
http://www.contextures.com/xlcomments03.html

"SirPoonga" wrote:

I am in the process of converting a spreadsheet to an access database.
The sheets I am working with have several cell comments. I would
like to know how to access each comment of each sheet adn figure out
what sheet and cell it is in.

Thanks in advance
Kevin

Thanks, I got this working
<pre

ff = FreeFile
Open "C:\comments.txt" For Output As #ff
For Each mySht In Worksheets
For Each mycomment In Worksheets(mySht.Name).Comments

Print #ff, Format(mycomment.Parent.Parent.Name, "!@@@@@@@@@@@@@") & _
Format(Number2Letter(mycomment.Parent.Column) & "," &
mycomment.Parent.row, "!@@@@@@") _
& mycomment.Text

Next mycomment
Next mySht
Close #ff

</pre

Output looks like
SHEET1 L,63 A comment here
SHEET2 A,3 ANOTHER COMMENT

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!