Compile error: Method or data member not found

Question

In VBA Excel, why this statement "Set dict = CreateObject (Scripting.Dictionary)" error:

"Compile error: Method or data member not found". How do I fix it. Please help me!

Answer 1

Try this, the Object needs to be in between double quotes:

Set dict = CreateObject("Scripting.Dictionary")

Hope this helps,

 

---

Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"

Answer 2

Make sure you have the correct references set in:

Tools... > References

---

gsnu201111

Answer 3

Also need double quotes:

 

Set dict = CreateObject("Scripting.Dictionary")

---

gsnu201111

Answer 4

Thank you very much.

Answer 5

Thank you, I did that then

Answer 6

Make sure you have the correct references set in:

Tools... > References

---

gsnu201111

When you have your References ticked, its early binding and the code look likes this for example:

Dim dict As Scripting.Dictionary
Set dict = New ScriptingDictionary

 

Or with one line:

Dim dict As New Scripting.Dictionary

In late binding, no references needed, and the code looks like this:

Dim dict As Object
Set dict = CreateObject("Scripting.Dictionary")

Advantage of using early binding is you can make use of the intellisense of the Object Library, while with late binding you don't have that available.

Most of the time I start in early binding, and then convert to late binding when done programming.

 

Hope this helps,

 

---

Daniel van den Berg | Washington, USA | "Anticipate the difficult by managing the easy"

Answer 7

Thank danishani