User-defined type not defined

[Noz2k]

I have a bit of code which usually opens up an ADODB connection, runs some sql and then returns the data to excel.

This works perfectly in 1 workbook, however when I copied over the code to a new workbook it is falling down right at the start giving me the message 'user-defined type not defined'

This is the beginning of the code

 Sub myConnection()
 
 Dim cnn As ADODB.Connection
 
   Dim MyRecordSet As ADODB.Recordset
   Dim SqlString As String
   Set cnn = New ADODB.Connection

and it falls down on the line 'Dim cnn As ADODB.Connection'

Any idea why this might be?

 

[Sektor]

Tools -> References -> Microsoft ActiveX Data Objects 2.8 Library

 

[Noz2k]

Thanks, I thought it might have been to do with the references (although am unsure why they're different). Wouldn't have had a clue which to turn on though. Thanks

 

[Sektor]

Take the latest.