title: Shape object of type msoLine - method to access coordinates of points?
body: <p>Is there a method for accessing the coordinates of the start and end point of an <code>msoLine</code> shape object? I am working with legacy files in Excel 2010 (from Excel 2003 I think).</p>
  
  <p>Given an <code>msoFreeform</code> object I can access the various coordinates in turn using something like:</p>
  
  <pre><code>  With myDocument.Shapes(i)
       If .Type = msoFreeform Then
         nodeCount = .Nodes.Count
         For k = 1 To nodeCount
           pointsArray = .Nodes.Item(k).Points
           X1 = pointsArray(1, 1)
           Y1 = pointsArray(1, 2)
         Next k
       End If
    End With
  </code></pre>
  
  <p>But this method fails for <code>msoLine</code> objects with the <code>.Nodes.Item(k).Points</code> returning nothing, even though <code>.Nodes.Count</code> returns <code>2</code> for a start point and an end point.</p>
  
  <p>Am I missing something?</p>