XYZ Coordinates Of Shapes Into Excel

[Jim Clayton]

Hello again.  So I'm going to attempt to try doing some AutoCAD drawings from Excel.  Keep in mind that I have no idea what I'm doing here.  My theory was to take some common assemblies, find a Lisp that can copy the XYZ details and paste them into Excel to be stored for later use.  I get a lot of the same requests for assemblies but all of the information is on Excel spreadsheets with dimensions.  If I could pre-load those dims with coordinates, then I could draw things pretty instantly.  But I need a Lisp to extract the XYZ information of assemblies and load it into Excel.   Also, if someone has a better method, feel free to throw it out there.  Tks.

[BIGAL]

You need to explain a dgw or image what is a assembly ?

[Jim Clayton]

Apologies... "Work-Speak" getting carried over into everyday life under the assumption that people know what I'm talking about. Basically just mechanical assemblies on dwg files. Things I've drawn previously.  I get requests for them over and over again on massive Excel spreadsheets.  You might be asking "why not just use templates?"  And currently I do. But I thought if I had the coordinates for each assembly type, then I could take the spreadsheet, use some VBA to cross reference the dimensions against a coordinate template, and load the coordinates in another column based on the dimensions. And in theory, do 200 drawings like lighting.  At the very least I'll learn a new skill. Thanks for the help.

[BIGAL]

You still have not explained need a dwg are we talking 3d solids ?

[Jim Clayton]

2d...so would actually just be XY

[BIGAL]

So need check what it is !

 

For pline a co-ords tick done

Arc ends Plus centre done

Circle cen pt done

Text insert point done

Lines end points done 

 

Its called dataextraction come with Autocad

 

 

[Jim Clayton]

Hmm... well sir, I thank you for your help. Let's see if I can make heads or tails of this.