anindya Posted August 22, 2014 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
BIGAL Posted August 22, 2014 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
anindya Posted August 23, 2014 Author 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
Renjith Posted May 25, 2016 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
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.