Import Points from MS Excel in Siemens NX by Journal #1

Small vb journal to demonstrate how to import arbitrary points from MS Excel into NX work part.
You can download the script from here (see Step 1):
grabcad.com/tutorials/how-to-...

[@krishnaphanindra1841]

Thanks..!! Very informative.

[@CADTutorialsSGT]

Thank you!

[@jerrychen1243]

Hello, may I ask, how did you create this excel? And another question which is kinda relevant, is it possible to import a NX/AutoCAD/Pro E/SolidWorks etc... drawing into excel? What I am is not copy and paste, but rather converting the drawings into points

[@CADTutorialsSGT]

Hello Jerry,
excel columns contain the X, Y, Z coordinates, here is a sample for you:
drive.google.com/drive/folders/0B5nRoLL_2Es1dG5FbEdFQzYyNjA
Your second question is possible, but it is complicated, small sample will be appreciated.

[@jdm1875]

okay, so how do you make this a spline now and make it a surface?

[@CADTutorialsSGT]

Sorry for my late answer, I had to edit the video...
Here you can see a solution with Through Curves:
ruclips.net/video/-QmiWfGG9_0/видео.html
Later I'm going to upload a version with Studio Surface.

[@devpujari1]

How to get the 3D points coordinates in excel? (Exact reverse case) Can you share the macro please?

[@CADTutorialsSGT]

Hi Devdatta Pujari,
earlier sobody has a similar question. It is not difficult, please be patient. I'm going to create a general macro (what kind of spline? sketch, model, drawing, etc.).
Thanks!

[@devpujari1]

@@CADTutorialsSGT Thank you very much. That will be really helpful. I just need to create Datum points coordinates chart. (X,Y,Z) to export in an excel sheet. So that I can use it to get into the drawing. Thanks again.🙂👍

[@CADTutorialsSGT]

@@devpujari1 In this case the macro differs, because we need the datum points info, not the spline information...

[@devpujari1]

@@CADTutorialsSGT Ok. Which is best to create a macro in NX? VB or VBA? If I want to create macro to export (X,Y,Z) coordinates in excel sheet. Thank you.

[@gautamsharma8014]

Hi, thanks for the video it's very helpful...can I also import the name of the point as I have in excel ??
For example
A. B. C. D.
X Y Z. Name
1. 4. 6. Subject1
......…....... Subject2
So that the final points will have names also from column D..
Can you please send me the the VB code for that as I don't know vba stuff.
I will be very helpful for me 🙂

[@CADTutorialsSGT]

Sorry for tha late answer. Yes you can, you need to modify the macro.