- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
We have been creating a rule by copy and pasting the same code again again into our files. The code is just a simple excel look up to find a row using the part number in the iproperties, then fill in the description and vendor
i = GoExcel.FindRow("P:\_MASTER_PART_LIST\MASTER_PART_LIST.xls", "MASTER_PART_LIST", "Part No.", "=", iProperties.Value("Project", "Part Number"))
If i <> -1
iProperties.Value("Project", "Description") = GoExcel.CurrentRowValue("Description")
iProperties.Value("Project", "Vendor") = GoExcel.CurrentRowValue("Manufacturer")
Else
iProperties.Value("Project", "Description") = "The entered Part Number does not exist in the Master Parts List"
iProperties.Value("Project", "Vendor") = "The entered Part Number does not exist in the Master Parts List"
End If
But this isn't going to be on every part and we want it internal because we need it to keep checking the excel through trigger upon save to the iproperties stays up to date passively.
Adding it has been frustrating so I was wondering if there way to have a external rule to create a internal rule within the part? So the user will just run the external rule, it will create the internal rule in what ever the active part is. Then that internal rule will be triggered upon save by another rule I have in the top level assembly?
Solved! Go to Solution.