I found a really good macro here:
https://forum.solidworks.com/thread/64356
and I have been tweaking it to my needs (and learning about VB and Solidworks API along the way) but I have hit a road block. How can I export Annotations (notes) to Microsoft Excel?
I am trying to export them for a feature map for a quality department to have a automatically generated list. I have a lot of drawings where notes are defining parts on the drawing, like (d1) (d2) (d3) where they are all seprate notes. I want them in the spreadsheet in a column. Here is a picture of what I am talking about:
http://i.imgur.com/qD9IvsF.jpg
SolidworksApi macros