AnsweredAssumed Answered

How do I create lines between points from excel file using Macros?

Question asked by Jonathan Snyder on Jul 20, 2020
Latest reply on Jul 22, 2020 by Niels Raahauge

Hi! This is my first post on these forums, and I'm in need of some help on writing macros!

 

There's two things I need help with. Firstly, I want to be able draw lines between points from an excel file. I was able to plot the points and fix them in a 3D sketch, but I want to connect them with a line.  Secondly, how do I make the Macro read the data in IPS (inches) instead of metric (meters)? I know I can convert it in the excel file (=CONVERT, *cell*, "m", "in"), but I'd like the Macros to automatically do that for me.

 

I've attached the excel file (I know it needs to be a txt file), my current macro (and a screenshot of it).

 

Any help would be greatly appreciated!

 

Thanks.

Outcomes