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

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

Answered with a tutorial: https://grabcad.com/tutorials/tutorial-how-to-export-points-from-solidworks-to-a-excel-file

it work.

Hi, Its not writing points in excel file. Can you please tell me how can I fix it.
Thanks

add
Dim exApp As Object
Dim sheet As Object
below the existing dim call out before the first set and it works like a charm

I added
Dim exApp As Object
Dim sheet As Object
Doesn't work. Is there something new needed for it to work in SW 2015?

Thanks!

Awesome! It works, thx!

I used the above macro to export nodal points of an fsae frame to Ansys Workbench. For some reason, the orientation of the points relative to each other is correct , however the distances between them a grealy reduced. The overall plot of the frame has been scaled down. Can anyone tell me why this has happened? It will be a great help.

I had to make some additional modifications to the file to get it work. You can also see how you can keep dimensions at their original size. Other notes: ensure that the sketch is selected before you run the macro.

My problem is in exporting X,Y and Z data of a helix sketch from solidworks to Excel. I checked the above macro, but it doesn't work for helix sketch. anybody can tell me how to fix it?