replace texts in two drawings together?

[ccy137]

Hi guys,

I have a question about AutoCAD and Excel VBA. Hope someone could help me.

I am working on a project to update some texts in drawings according customer inputs from Excel files. The texts are descriptions of production line. For each production line, there is a production identification number, like P001,P002,P003....These production line numbers also used in other drawings.

Right now, i could update production line descriptions and production line numbers from Excel files. For example, I have drawing 1 with production line descriptions and production line numbers. There is a drawing 2 using these production line numbers, too. What I want to do is, every time I update those production line numbers (in drawing 1), the production line numbers in drawing 2 will changed automatically.

Does anyone know how to do this?

Thanks in advance for all your help.

Matt

[bob.vandusen]

Look here: http://cadtips.cadalyst.com/notestex...gs-a-directory

[ccy137]

Look here:

Hi Bob,

This is a really good tip to know, but it can't resolve my problem. let me explain my question in detail.

For each project, we have two group drawings. In group one, each drawing gathers similar products together. Group two drawings contain product information stored in group one drawings.

For example, In group one drawings 1,2,3, left column is production line number and right column is production line description. In group two drawing1,2,3 left column is production line number and right column is abbreviation of production line description.

When update drawings in group 1, there is no change of production line number. The only change is the product descriptions. For example, In group one drawing 1, If the product description of P108 has been change to VVVVVVVVVVVV, in group two drawing 3, the product short description #fgh has to be changed to #asg.

Right now, I could update group 1 drawings through getting inputs from excel files. For one project, in group one, we have 10 drawings. In group two, we have 20-30 drawings.

Does anyone know how to solve this problem?

I am thinking, is there a method of embedding a link into a text, when this text changed, the related text in other drawings will be changed automatically??

Thanks for all replies.

Matt


*************GROUP 1 Drawings**********************
Drawing 1 Contian following information
P101 agaaaaaaaaaaa
P102 bbbbdbbbbbbbb
P103 cccccgccccccc
P104 ddddddddddddd
P105 eeeeeeegeeeee
.....................................
P108 ffffffffhfffffffffffffffffff
P110 gggggsgggggggg
.....................................
P116 hhhhhhhfhhhhhh

Drawing 2 Contian following information
P201 aaaaaaaaaaaaa
P202 bbbbbbbfbbbbb
P203 ccccccchccccc
P204 ddddddddhdddd
P205 eeeeeeeeheeee
.....................................
P208 ffffffffffffffffffffhffffffff
P210 ggggggggdggggg
.....................................
P216 hhhhhhhjhhhhhh

Drawing 3 Contian following information
P301 aaaaaaaaqaaaa
P302 bbbbbbbbwbbbb
P303 ccccccccrcccc
P304 ddddddddddtdd
P305 eeeeeeeeeeyee
.....................................
P308 ffffffffffffffffffffffuffffff
P310 gggggggigggggg
.....................................
P316 hhhhhhhhhhghhh


****************GROUP 2 Drawings**********************
Drwing 1 Contain following information
P101 #abc
P306 #cde

Drawing 2 Contain following information
P202 #def

Drawing 3 Contian foloowing information
P108 #efg
P315 #fgh
......................................
......................................

[CADfunk MC]

If you can use an excel file to update the files in group 1, why don't you improve that excel file slightly so it wil also update te information in the drawings of group 2?