AnsweredAssumed Answered

Exporting Custom Properties to Excel and Receiving Custom Properties Back

Question asked by Peter Kennedy on Jan 26, 2016
Latest reply on Jan 27, 2016 by Matt Martens

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.