3 Replies Latest reply on Jan 24, 2017 11:54 AM by Raghvendra Bhargava

    Excel data to Solidworks Custom properties - Macro needed!

    Prasanna Ashok

      Hi,

      I have a problem.

       

      I have 300 part files and their properties like Ref no, vendor no, Material in excel file.

       

      Can someone give me macro, so that it reads the part number and imports the corresponding row details?

       

      Capture.JPG

      If i open 566601f part and the run the macro, i want to get Ref no-233, Vendor No-L.S and Materal-SS316 in model properties.

      Note: Already I have few properties entered in the model. These are extra properties which i need to add now.

      Using 2016 Solidworks now.

       

      Please help me with macro.