Message 1 of 4
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hi,
I've got two iLogic rules, but one of them seems to trigger the other somehow.
Rule 1 = Assemble
Rule 2 = Check Excel
When i check the Excel, it somehow runs Rule 1 after it's finished, but i don't understand why.
Rule 2 code:
Imports System.Text.RegularExpressions
Imports Microsoft.VisualBasic.FileIO
Sub Main()
Dim oDoc As Inventor.Document = ThisDoc.Document
Dim oSourceFile As String = "X:\Path\Test.xlsx"
Dim CellCounter As Integer = 1
Dim FileTotal As Integer = 4
Do While CellCounter < FileTotal
Parameter("Type") = GoExcel.CellValue(oSourceFile, "Blad1", "A" & CellCounter).ToString
Parameter("Vermogen") = GoExcel.CellValue(oSourceFile, "Blad1", "B" & CellCounter).ToString
Parameter("Motorflens") = GoExcel.CellValue(oSourceFile, "Blad1", "C" & CellCounter).ToString
Parameter("Rem") = GoExcel.CellValue(oSourceFile, "Blad1", "D" & CellCounter).ToString
Parameter("Handrem") = GoExcel.CellValue(oSourceFile, "Blad1", "E" & CellCounter).ToString
Parameter("Handrem_Positie") = GoExcel.CellValue(oSourceFile, "Blad1", "F" & CellCounter).ToString
Parameter("Wartelpositie") = GoExcel.CellValue(oSourceFile, "Blad1", "G" & CellCounter).ToString
Parameter("Bestandsnaam") = GoExcel.CellValue(oSourceFile, "Blad1", "H" & CellCounter).ToString
Parameter("Opslaan") = "Ja"
CellCounter = CellCounter + 1
Loop
End Sub
Why is this happening? i disabled all event triggers
Additional information of which i'm not sure wether it's important; The paramater are present in rule 1 as well and get used for the assembly.
Solved! Go to Solution.