Ask and answer questions and download tutorials

Thousands of tutorials to learn from

Feed

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

By Amin Kashef on 14 Nov 09:04 8 answers 25655 views 1 comment

In this tutorial we learn how to export points from sketches in solidworks to a spreadsheet (excel) file.

8 answers

  • Tabassum Qureshi
    Tabassum Qureshi about 4 years ago

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

  • Jonathan Fake
    Jonathan Fake about 3 years ago

    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

  • aaron reyes
    aaron reyes almost 2 years ago

    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!

  • Sujay Desai
    Sujay Desai 4 months ago

    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.

  • Michael Heyns
    Michael Heyns 4 months ago

    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.

    Attachments

    PointToExcel.swp, 49 KB
    Download

Add your answer to: "Tutorial-How to export points from solidworks to a excel file!"

Save Cancel