TROV-103
New member
- Jan 12, 2021
- 1
Hi everyone,
I am trying to automate a script using Visual Basic to read a component name from an excel file (column 1), then in NX, replace that component with another component reading the name in column 2 of the excel file. The reason for this automation is to replace labels rapidly whiteout having to do one by one because there can be up to 100 labels in an assembly. No constraints to be maintained, just position. I am working in NX12. I started with a journal but it gets tricky as I have never used VB before. I can attach my code thus far. Any help is much appreciated.
Also would like to add an If statement that if the condition where column 2 is blank, the part in column 1 is deleted and no replaced.
Please le me know if this is even possible. Thanks in advance
I am trying to automate a script using Visual Basic to read a component name from an excel file (column 1), then in NX, replace that component with another component reading the name in column 2 of the excel file. The reason for this automation is to replace labels rapidly whiteout having to do one by one because there can be up to 100 labels in an assembly. No constraints to be maintained, just position. I am working in NX12. I started with a journal but it gets tricky as I have never used VB before. I can attach my code thus far. Any help is much appreciated.
Also would like to add an If statement that if the condition where column 2 is blank, the part in column 1 is deleted and no replaced.
Please le me know if this is even possible. Thanks in advance