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