If you have the custom properties in an excel file and you want them as custom properties in a part, then you could insert a design table in the part and then cut and paste the properties from your spreadsheet to the design table
Thank you for you respond
I think what you suggestingwould work for one file at the time or dot file.
What I real need is populate each unique Part Number/File, of solid works file that has same name
as column Part Number so the Sldwks file is = 700001
and write in this file data from column, Description1; Description2; MFG P/N#; MFG; VENDOR P/N#; VENDORECODE; VENDOR; to custom properties
and then due this for next 700003; 700004; 700005; 700006, etc via automatic mode or SLDWKS Scheduler I have more then 2000 files to update with unique date for each 7000 series file
that sounds like something the API could handle. I would re-post your question in the API section.
also there are some third part softwares that edit custom properties on groups of files, not sure they can do everthing you would want though.
If I understand you correctly look into creating a tab builder file.
Once setup all you have to do is open your file, open the tab builder
and the properties are automatically added.
This can be easily done by macro.
Search API section. This has been discussed several times.
You can put your question in API section also.
You need a way to open files one by one automatially. Once you achieve this, you can run second part of the macro where you connect to excel file and copy data to properties.