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)