Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
ABoaro
in reply to: omartin

After tediously going line by line and commenting out and determining what works, I found that the invocation error was fixed when I did the following change:

Dim EmptyDictionary As New Dictionary(Of String, Integer)

to this:

 

Dim EmptyDictionary = New Dictionary(Of String, Integer)

The null error appeared to have gone away with this fix. Unsure how this differs from the first declaration of the empty dictionary.  

 

My next error occurs when I am looping through the excel columns. GoExcel seems to only like character indices when getting a specific value. I get an error message about looping through the columns:

 

System.ArgumentException: Argument 'Limit' is Nothing.
at Microsoft.VisualBasic.CompilerServices.ObjectFlowControl.ForLoopControl.ForLoopInitObj(Object Counter, Object Start, Object Limit, Object StepValue, Object& LoopForResult, Object& CounterResult)
at ThisRule.Main()
at Autodesk.iLogic.Exec.AppDomExec.ExecRuleInAssembly(Assembly assem)
at iLogic.RuleEvalContainer.ExecRuleEval(String execRule)

 

Not sure if you can help with that at least. I know you are weary of Excel.