3d Coordinates of a point

[tambraton]

Good Day to you sir! Newbie inventor user here.

Would anyone know how to assign a 3d coordinate in space, and have it linked directly to a excel spreadsheet - so updates/changes to the excel can be reflected in the points? (key idea is linked to the excel sheet)

The situation is like this:
-I have 18 (could be 200 in the future) points located in 3D space.
-I know how and can import these points into a 3D sketch no problem.
- BUT - how would I link each point and its 3 coordinates to the excel sheet, so when a change is made to the excel sheet, I can update the points?

The only way I can figure it out is by manually dimensioning each point to the origin x,y,z planes.

Is this the only way? What to do with 200 points?

Any help would be greatly appreciated.

Regards

tb

 

[EnginurrUpInHurr]

I know a method via Visual Basic for Applications. Are you familiar with VBA at all?

You can link to an excel sheet and use the values in cells to create 3D points. I'll try and post the code when I get into work on Monday.