10 Replies Latest reply on Jan 27, 2016 2:59 PM by Matt Martens

    Exporting Custom Properties to Excel and Receiving Custom Properties Back

    Peter Kennedy

      I have a question and I'm not sure if it is possible and my experience with Solidworks API is basically non-existent.


      I have custom properties set-up in my part and assembly files, there is 3 main properties that I would like to export to excel (Category Number, B/P Number and Description). Now I currently have an excel file with that will take these 3 inputs and save them into a chart and produce a File Number. The file number is just a unique number to save each part and assembly as a unique number for our Vault.


      What I would like the program to do is:


      View custom properties to make sure the 3 fields are filled out

      If not prompt the user for the information

      Open Excel

      Use the current macro to get the File Number (this also saves the data into a chart)

      Send File Number to Solidworks custom properties

      Close Excel

      Save the Solidworks file as the new file number.


      If anyone could provide any help that would be greatly appreciated.


      I can give my excel file if it will help.