2 Replies Latest reply on May 4, 2014 2:59 PM by Jerry Steiger

Use Macros to Import Curves from Excel

Mike Pacillo Jul 2, 2014 7:13 AM

Hi guys,

I conducted something which overburdens me a little :-).

What I would like to have is the shown helices and 2 sketches in the picture all created (or maybe at least partially) by a macro.

I found [url=https://forum.solidworks.com/message/178573#178573]this thread[/url] and the macro of Peter Simpson. Unfortunately it creates points, not curves and I am not able to open the macro to see how it works. Help would be very much appreciated, but please keep in mind, that I am a beginner with macros.

Greetings

Mike

PS: I am using SW at work, how can I find out the serial-number?

Re: Use Macros to Import Curves from Excel

Mike Pacillo Apr 16, 2014 5:13 AM (in response to Mike Pacillo)

Im sorry, that wasnt quite correct.

Peters macro does create curves but the are made by connecting the given points linear. So its not like a nice smooth curve like SW does it, e.g. in my picture.
Like Show 0 Likes(0)

Actions
Re: Use Macros to Import Curves from Excel

Jerry Steiger May 4, 2014 2:59 PM (in response to Mike Pacillo)

Mike,

I think you want to use the Curve Through Reference Points or Curve Through XYZ Points feature in SolidWorks. You would import the points from Excel. I've never done it but, you can probably search in the forums to find more information on the features. Or search the Help in SolidWorks.

Speaking of searching Help, to find out your serial number, select Help/About SolidWorks.

Jerry S.
Like Show 0 Likes(0)

Actions

Go to original post