Jump to content

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


hip280

Recommended Posts

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...