Getting values that are in mtext

[UncleCake]

Can I write a routine in VBA that will retrieve all of the mtext boxes in a drawing and write them to an Excel file? I can do the Excel part, but I don't know if and how to pull the values from a drawing in AutoCAD 2002.

-Uncle Cake

 

[Jetwax]

I have the same question as you.

My boss has tasked me with entering a bunch of text data (tag names, descriptions and addresses) from an autocad drawing he produces (electrical schematic) into MS Excel so that it can be then imported into Control Logix and form the tag database.

The electrical schematic contains a depiction of an IO card with an assortment of tag names and circuitry connecting them with their respective pins.

I am looking for help/suggestions in getting the different Mtext text out of autocad and into a csv file.

The idea solution (as far as I can see) would be to select the text and hit ctrl + (some key) and then the macro would copy the text and paste it into the next row in excel. I can write code to paste into the next row in excel. My problem is that I cant get a macro to run with a ctrl + (some key) and I am unable to write the code to copy the text.

Any help/suggestions/references that you could point me too would be greatly appreciated.

I know there has to be a faster, more accurate of getting these approx 6000 tags out of autocad and into a .csv file.


Thank you very much.

Erica Ashworth