AnsweredAssumed Answered

Excel Functions in Solidworks API

Question asked by Steve Mlynczak on Aug 20, 2015
Latest reply on Aug 21, 2015 by Ivana Kolin

Can some one give me an VBA example of using the vlookup function from Excel in a Solidworks macro. I want to reference an active Excel spread sheet and pull data from it based on Custom properties from the SW part. Maybe this isn't possible. This is what I was trying to make work.

 

ItemNumber = xlsh.WorksheetFunction.Vlookup("Stop Block", Range("D1:G25"), 4, False)

 

Outcomes