anindya Posted August 22, 2014 Share Posted August 22, 2014 hi i have one auto cad drawing where many points are pasted with their x,y and z value and also their description.i need the points x,y,z,and description on excel.i cannot transfer those points to excel with all their values.i attached a drawing for assistance.is that possible through vba ?? drawing123.dwg Quote Link to comment Share on other sites More sharing options...
BIGAL Posted August 22, 2014 Share Posted August 22, 2014 This is pretty easy as your objects are mtext its just case of selecting via a filter the correct mtext, if you search here or google for Export MTEXT, check Lee-mac.com, there will be lots of lisps you can try adding VBA to search and should get an answer as well. I dont have a specific one for this else would have posted you will end up with a csv file 1 line per mtext. Quote Link to comment Share on other sites More sharing options...
anindya Posted August 23, 2014 Author Share Posted August 23, 2014 i cannot find useful lisp for that one which gives me points coordinates like EASTING,NORTHING,ELEVATION,CODE,in separate column in excel from autocade drawing.ple give me any lisp or vba code for that one. Quote Link to comment Share on other sites More sharing options...
Renjith Posted May 25, 2016 Share Posted May 25, 2016 i cannot find useful lisp for that one which gives me points coordinates like EASTING,NORTHING,ELEVATION in separate column in excel from autocade drawing.ple give me any lisp or vba code for that one. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.