Tutorial-How to export points from solidworks to a excel file!

By Amin Kashef on November 14th, 2012 1 comment

the macro below used for exporting points from sketch to excel !

  1. Step 1

    For example we have these points in the 3Dsketch Below to export to excel


  2. Step 2

    go to tool --> macro --> new
    choose a name for macro and click save


  3. Step 3

    In the programming window write code below ( download the .swp I attached, the whole code didn't fit in picture!)


  4. Step 4

    Choose the sketch you want to export points from!


  5. Step 5

    tool--> macro--> run


  6. Step 6

    select the macro you write (or I uploaded) and click open


  7. Step 7

    the points will be write in a excel file as below


1 comment

  • himanshu khandelwal

    himanshu khandelwal 15 days ago

    is it necessary that all the points must be only in one sketch?
    how can we export the coordinate from a single SLDPRT file but from different sketches .

    himanshu khandelwal has uploaded 0 CAD models & has left 1 comments.
  • Please log in to add comments.

    Log in

Save Cancel