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

Amin Kashef

14 Nov, 2012 04:06 PM

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