Text

[StriderNJ]

Firstly Hello to everyone. This is my first post but I do not believe it will be my last.
I am using AutoCad 2000.
Is it possible to extract text from a drawing and place it into either Microsoft Excel or Microsoft Access. Some people might know where I am going with this. Essentially I want to be able to lift text from the drawing and create schedules/cutting lists.
Thank you in advance for any help you may be able to give me.

[robfowler]

It is possible to select the mtext in a drawing > right-click > select Mtext Edit > highlight the text in the Multiline Text Editor > copy using the Wndows Copy tool > got to MS Excell > select required cell > Paste in the text.

This seems quite cumbersome for each piece of text though but I don't have a need to do this and there may be a much better way.

You may want to look up the Acad Help files for Parts Lists > Extracting Attribute Information.

Rob.

[fuccaro]

Hello StriderNJ!
About exporting text from your drawing you may read in thw Autolisp section -here:
http://www.cadtutor.net/forum/viewtopic.php?t=75
This will export to a TXT file, but it is possible to import the text in Excell. Or if you wish to work the text first, open the TXT file in MS Word and make the adjustments.
It is possible (I think) to rewrite the Lisp to export directly to Excell.