Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!
Getting values that are in mtext
- Thread starter UncleCake
- Start date
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
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
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
