×
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

thread559-153131 - excel table with points'coordinates of a cut line

thread559-153131 - excel table with points'coordinates of a cut line

thread559-153131 - excel table with points'coordinates of a cut line

(OP)
Hi Handleman,
Can I ask you if you have a vba solution with solidworks to get some points of intersections in an excel table ?

Here I join a little explanation of my issue.

Many thanks in advance for heeling on it.

Michel

RE: thread559-153131 - excel table with points'coordinates of a cut line

Create a 3D sketch and dimension in XYZ to the origin.  Create a design table and add those dimensions.  No VBA needed.  I hope this helps.

Rob Stupplebeen

RE: thread559-153131 - excel table with points'coordinates of a cut line

(OP)
Hi Rob,
Many thanks for your reply. I am going to try your solution. I must have a look on how it works because I've never worked with that option "design table" in solidworks.

Many thanks again.
Michel Descamps

RE: thread559-153131 - excel table with points'coordinates of a cut line

Michel,

If you already have the 3D model you can create an Intersection curve between your sketch plane and the Top surface of the model and then create a series of points on the Intersection spline and add on plane or coincident relations to a plane or a pierce point to a section curve that passes through plane.

If you are looking for a Visual Basic way I can offer a suggestion to try using Reference Geometry > Points because there is an equal space along curve max 100 points or a percentage option with more than 1 instance also maxes out a 100.

SolidWorks froze up on me just now because I lost the Measure dialog. I'm attaching a few pictures and will put example model up soon.
sw_intersection-curve+relation
sw_refPoints_on_curve_100max
sw_Selected_Point_XYZ_status-bar

Michael

RE: thread559-153131 - excel table with points'coordinates of a cut line

(OP)
Many many thanks Michael.
I think your idea of 'Reference geometry' would be a very good solution because what I 'd like to obtain is at least 100 points for each intersection profile at equal distance each others and beginning from the leading edges of the profiles.
Many thanks again ,I 'll try it.
...But not at once ...I hope here on Christmas Holidays because my PC is broken down for the moment.
I 'll say you .
I wish you a Merry Christmas and Happy New Year.
Michel

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