8 Replies Latest reply on Apr 3, 2014 10:26 AM by Jacob Cordingley

    Fill in custom properties from Excel workbook

    Damon Frashure

      I have a bunch of new files I've been working on for a design project but none of them have the custom properties filled in.  So I'm looking with some help on a macro that will read an excel file in, find a solidworks file by the name in column A (from within a specified directory), create the custom property field in Row 1 and then fill them in with the appropriate data from teh Excel file.  Does something like this already exist?  Is it possible to pull data out of other files from within the API?  Thanks in advance.

       

                                         Part Number      Description                     Vendor           Vendor No.      Etc

      12345.sldprt  ==>         12345               Something Descriptive     Someone         Something      Something Else