×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

3d Coordinates of a point

3d Coordinates of a point

3d Coordinates of a point

(OP)
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

RE: 3d Coordinates of a point

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.

  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources