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

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.

SolidworksApi/macros