Consulting

Results 1 to 5 of 5

Thread: checkdic as dictionary

  1. #1

    checkdic as dictionary

    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?

  2. #2

  3. #3
    VBAX Expert
    Joined
    Jul 2004
    Location
    Wilmington, DE
    Posts
    600
    Location
    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

  4. #4
    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") ?

  5. #5
    Set r = New ADOR.Recordset
    ' Add the column
    r.Fields.Append "Component", adVarChar, 50

    it gives the same error for adVarChar. how to debug?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •