Compiler Error: User-defined types not defined

by

I had forgotten to add a reference to “Microsoft ActiveX Data Objects 2.5 Library”: This reference is required for early binding.

How to get to that reference:

Tools > References > Check the checkbox in front of “Microsoft ActiveX Data Objects 2.5 Library”

Other libraries that work include:

Microsoft ActiveX Data Objects 2.6 Library

Microsoft ActiveX Data Objects 2.7 Library

Microsoft ActiveX Data Objects 2.8 Library

Microsoft ActiveX Data Objects 6.1 Library

More Related Contents:

  1. to make this code simpler
  2. VBA – How to grab the cell below if a cell has text?
  3. VBA code takes long time to execute in excel
  4. How can I insert variable into formula in VBA
  5. Code in VBA loops and never ends. How to fix this?
  6. Excel VBA deleting rows in a for loop misses rows
  7. What is the lifetime of a global variable in excel vba?
  8. Download attachment from Outlook and Open in Excel
  9. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  10. Embed picture in outlook mail body excel vba
  11. How to check for empty array in vba macro [duplicate]
  12. Use autofilter on more than 2 criteria
  13. Searching an excel with two search words (multiple lookup) using vba macro [closed]
  14. What is the function of FormulaR1C1?
  15. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  16. Load csv file into a VBA array rather than Excel Sheet
  17. Insert line break in wrapped cell via code
  18. Change color of certain characters in a cell
  19. Sheet protection: UserInterFaceOnly gone
  20. VBScript – How to make program wait until process has finished?
  21. Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
  22. VBA Macro crashes after 32000 rows
  23. How to create dynamic variable names VBA
  24. How to break a long string into multiple lines
  25. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  26. How to get address of cell which calls a VBA Functions in a Excel sheet
  27. simple vba code gives me run time error 91 object variable or with block not set
  28. How to have vba execute every 10 minutes?
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment