7 Replies Latest reply on Aug 21, 2015 8:43 AM by Ivana Kolin

    Excel Functions in Solidworks API

    Steve Mlynczak

      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)