Coordinates of two endpoints of a line segment

[northwolves]

Any one knows how to use VBA to get the coordinates of two endpoints of a line segment in a worksheet? Million thanks.

 

[Rick Rothstein]

Any one knows how to use VBA to get the coordinates of two endpoints of a line segment in a worksheet?

When you say "line segment", do you mean a Line Shape?

How did you want an end point returned to you... as a single text string like (12,34) or as two separate numbers in two separate cells?

 

[northwolves]

Thanks for your reply. We use the example from MSDN:

Set myDocument = Worksheets(1) 
With myDocument.Shapes.AddLine(10, 10, 250, 250).Line 
 .DashStyle = msoLineDashDotDot 
 .ForeColor.RGB = RGB(50, 0, 128) 
End With

Then we get a shape line. when we save and reopen the document, how can we get the coordinates of two endpoints(10,10),(250,250) by codes?