exporting comments?
 

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

exporting comments?
 

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

exporting comments?
 

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

exporting comments?
 

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!