I am trying to write a macro that will find a note on a drawing.  This note happens to be on the Sheet Format, but I do not really know location so can only think to go through all notes until I find the one with the right contents.  The only thing I really know is the contents.  The problem is the contents I need to search for I am not able to find the right property for.  You can also see this in the solidworks interface.

I am looking for the note that contains this as its contents...

\\\$PRPSHEET:"material" (shown when using 'Edit Text in Window')

trouble is this variable in the note seems to be resolved to the value of the variable in all API properties I have tried.  For example...

STEEL, ASTM A36 (shown when double clicking, or just selecting 'Edit Text')

I can get the note text by the GetText() function call, but this gets the value of the variable, not the name of the variable.

Debug.Print note.GetText

I would really like to do something like this.

while note.getText <> "\\\$PRPSHEET:""material"""

     found = false

     set note = note.getnext()

wend

but the above will never be true.  I am also trying to find one note that has the value of \\\$PRP:"scale"  Anybody got any ideas on how to track down this note?

--Matt