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
  • Comment • 1
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

No one else has this question

Outcomes