Hello,
 
I've got the following question for Autocad 2007 users:
I've a drawing in Autocad 2007 with all kind of blocks on it. If you click  on a block, and you click your right-mouse-button and go to properties, then it will display the x-y coordinates of that particular block, along with other information. Now my question is: is it possible to automatically generate a list of all this coordinates of all blocks in my drawing, together with the block name and a attribute, in my case called blockcode? Cause there are about 100 blocks and it is very time-consuming to do it by hand. Is it also possible to generate this list in excel?
 
Thanks!
 
 

Yes, you can use the AutoCAD commands ATTEXT, EATTEXT or DATAEXTRACTION (see AutoCAD commands). For bidirectional links (controlling coordinates and attributes from Excel) you can use Excellink.

Thanks for your info! Nevertheless, I tried it but I didn't get the result that I wanted cause I'm something doing wrong. Can you please tell me step-by-step what to do with the commands in more details? Thank you very much for your help!
 
Greetswillems2008-08-27 19:58:00

See the Tip 6289 and Tip 4865.

I tried it this way and I came up with an table of the coordinates in autocad and excel. Unfortunally, the coordinates in excel and autocad-table didn't match the coordinates that Autocad gives in the block of a selected point. How is this possible and how can I cope with this?
Thanks!
 
 

you could also use ImportPoints for AutoCAD (it's a freeware, so it's not perfect, but works well generating blocks and attributes from dbf, csv, txt, xls, odbc...)You can download this AutoCAD addon for free here in abc autocad

Hi,
 
you can use Acad 'eattext' command (or from menu tools/attribute extraction). Ussing this you can get a lot of information about any blocks and attributes in the drawing(and more). You have to mark the information you need and you'll get a 'csv' file with the requred information.
Please try it, and if any questions appears please ask me again.