Extracting points from line, polylines, arcs etc into excel using VBA

[hip280]

Hi I usually have drawings with lots of line, polyline, arcs etc. I would like to extract the coordinate points that form them automatically into Excel using VBA.

However, many books I come across teach how to create drawings using VBA but not to extract data from drawings using VBA. As such I am not be able to find a good example that does this.

I would like to be able to select the lines, polyline etc that I want from the drawing. And have the VBA code go through each item in the selection set and outputs the coordinates into excel.

Can anyone provide me with some code to do this?
Thank You
Roy

[borgunit]

http://www.cadtutor.net/forum/showth...ct+coordinates