Cell Pop-Up Notes: Any way to extract them programatically?

I've got a sheet that lists various mutual funds and their returns in
it's columns.

However, somebody has put the inception date of each fund in a pop-up
note attached to the fund column. i.e. the cell with fund's name has
a little red triangle in it's upper right corner and when the cursor
hovers over it, a yellow note pops up.

I'm going at this sheet via a VBA Excel.Application object and would
like to extract this data.

My guess would be that each cell can have a collection of
something-or-other that points to the pop-up notes.

Anybody know for sure?

There's sample code here for extracting comment text:

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

PeteCresswell wrote:
> I've got a sheet that lists various mutual funds and their returns in
> it's columns.
>
> However, somebody has put the inception date of each fund in a pop-up
> note attached to the fund column. i.e. the cell with fund's name has
> a little red triangle in it's upper right corner and when the cursor
> hovers over it, a yellow note pops up.
>
> I'm going at this sheet via a VBA Excel.Application object and would
> like to extract this data.
>
> My guess would be that each cell can have a collection of
> something-or-other that points to the pop-up notes.
>
> Anybody know for sure?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

RE:
-------------------------
For Each cmt In ActiveSheet.Comments
.Selection.TypeText cmt.Parent.Address _
& vbTab & cmt.Text
.Selection.TypeParagraph
Next
--------------------------

Thanks Debra - that was precisely what I was looking for.
--
PeteCresswell

You're welcome. Thanks for letting me know.

(Pete Cresswell) wrote:
> RE:
> -------------------------
> For Each cmt In ActiveSheet.Comments
> .Selection.TypeText cmt.Parent.Address _
> & vbTab & cmt.Text
> .Selection.TypeParagraph
> Next
> --------------------------
>
> Thanks Debra - that was precisely what I was looking for.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html