Auto create parts from excel-file

[Molgan]

Hi,

I want to have a macro/API to do the following:
1. Create a new part.
2. Read 3d-coordinates from the first line in a file (ie excel)
3. Sketch lines between the coordinates
4. Make an extrusion from the sketched lines.
5. Save the part as part1.sldprt
6. Create a new part.
7. Read 3d-coordinates from the second line...
...extrude
...save the file as part2.sldprt
3rd line
part3.sldprt
and so on...

Is this even possible?

Thanks,
Magnus

 

[TheTick]

Yes, it is.

Honesty may be the best policy, but insanity is a better defense.

http://www.EsoxRepublic.com

-SolidWorks API VB programming help

 

[Molgan]

fantastic!
Can you tell me how? Please....

 

[rstupplebeen]

Create a model with a design table of each case you need. Then run a macro to save out each configurations. Attached is the macro. I hope this helps.

Rob Stupplebeen

 

[Molgan]

rstupplebeen:
Thanks for the macro. But i'm looking at somewhere around 2000 configs...

 

[handleman]

It would be a very ambitious first macro. If you've never written macros before (which it sounds like you haven't), it would take you longer to learn enough to write this macro than to create your 2000 parts manually. Maybe someone will have time to work for you for free, but it's not me today.

-handleman, CSWP (The new, easy test)