Strange error when creating scripting.dictionary: In order to evaluate an indexed property, the property must be qualified and the arguments must be

[Peter Ferber]

I am using a Scripting.Dictionary (Interop.Scripting) object, inherited from VBA code, to create a dictionary, but I am unable to see the details when debugging. To simplify this, I have created a very simple set of code and observed it:


Sub Test_CreateDictionary()
Dim dicTest As New Scripting.Dictionary
dicTest.Add("A", 1)
dicTest.Add("B", 2)
dicTest.Add("C", 3)
Stop
End Sub

When I did this in VBA, I was able to see the list of items in my dictionary. Now, I am getting the error shown in the title, and my ability to retrieve values is error prone. Any insight would be appreciated, including this question: Is there a .Net version of the data dictionary I should be using?

Continue reading...