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

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