AnsweredAssumed Answered

How to transfer Custom Properties from Excel File

Question asked by Alex Deptala on Mar 17, 2011
Latest reply on Mar 18, 2011 by Deepak Gupta
Part   NumberDescription 1Description 2MFG P/N#MFGVENDOR P/N#VENDORE CODEVENDOR
700001SPACER RND 18-8 SS #8 SCR 0.50LGX0.312OD 92320A445MCMAST680McMaster-Carr   SUP.Co.
700002SPRING COMPRESSION MUSIC WIRE 0.312ODX1.50LGX0.023DIA 9657K107MCMAST680McMaster-Carr   SUP.Co.
700003SPACER RND CERAM 0.140IDX0.25ODX0.25LG 96109A160MCMAST680McMaster-Carr   SUP.Co.
700004GROMMET RUBBER BUNA N AN391 #2101/8IDX11/32ODX3/16WALL 9307K35MCMAST680McMaster-Carr   SUP.Co.
700005CNTRL DUAL DISP RED/GRN PID 1/16 DIN 24-28VDC SD6C-LCAA-AARGWatlow Electric Mfg.   Co.SD6C-LCAA-AARG
Watlow Electric Mfg. Co.
700006TEE FEM FLERTPFA TBE 1/2 OD UT8T-8-8TFN-1EntegrisUT8T-8-8TFN-1VALINC161Valin   Corporation
700007UNION STRAIGHT FLERTPFA TBE 1/2ODSU8FN-1EntegrisSU8FN-1VALINC161Valin   Corporation
700008ELBOW FLERTMALE 90 DEG PFA TBE 1/2ODE8-8TFN-1EntegrisE8-8TFN-1VALINC161Valin   Corporation

 

How I can export the custom properties via macro all other miens across different parts

not a drawings automatically

 

I need 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.

 

Thanks

Alex

Outcomes