AnsweredAssumed Answered

SW/Excel find value

Question asked by Damon Frashure on Jul 31, 2014
Latest reply on Aug 4, 2014 by Damon Frashure

Hello,

 

 

I'm working on a macro that should find a value in column A of the active Excel sheet, return the row number to the API, and then use that value to tranverse the row using the values to create custom properties.  I was able to write a very simple macro that will use a hard coded row number to make the custom properties, but I can't figure out the finding the part about finding the value programmatically.  Does anyone have any thoughts on how to do this?  Also, can anyone point me toward a resource about the different excel functions available in the SolidWorks API?

 

Thanks in advance.

Outcomes