×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Auto create parts from excel-file

Auto create parts from excel-file

Auto create parts from excel-file

(OP)
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

RE: Auto create parts from excel-file

Yes, it is.

batHonesty may be the best policy, but insanity is a better defense.bat
http://www.EsoxRepublic.com-SolidWorks API VB programming help

RE: Auto create parts from excel-file

(OP)
fantastic!
Can you tell me how? Please....

RE: Auto create parts from excel-file

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

RE: Auto create parts from excel-file

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)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources