I have checkdic as dictionary in my coding and when running I get this error: cannot find project or library. What control should I have?
I have checkdic as dictionary in my coding and when running I get this error: cannot find project or library. What control should I have?
You need to either:
1) Set a reference to Microsoft Scripting Runtime or
2) Declare checkdic as Object, then use a line like this:
[VBA]
Set checkdic = CreateObject("Scripting.Dictionary")
[/VBA]
Regards,
Patrick
I wept for myself because I had no PivotTable.
Then I met a man who had no AutoFilter.
Microsoft MVP for Excel, 2007 & 2008
I have refrence to microsoft scripting run time, but it gives me cannot find project or library.
I declared checkdic as Private CheckDic As Dictionary, Is it different than difining it as object and then add Set checkdic = CreateObject("Scripting.Dictionary") ?
Set r = New ADOR.Recordset
' Add the column
r.Fields.Append "Component", adVarChar, 50
it gives the same error for adVarChar. how to debug?