User defined type not defined ?? Excel VBA

[nslemmons]

Hi everyone,
I copied a handful of functions to get data from a group of Excel workbooks in a directory I defined in the code. I'm not really good with VBA so I'm stumped pretty easily when something like this happens. Below is the code snippet.

Public Sub GetData(SourceFile As Variant, SourceSheet As String, _
                   sourceRange As String, TargetRange As Range, HeaderRow As Boolean)

    ' Changed on 20-Oct-2005
    Dim rsData As ADODB.Recordset
    Dim szConnect As String
    Dim szSQL As String
    Dim lCount As Long

The "ADODB.Recordset" is what is highlighted when the error occurs. Any help is appreciated.

Thanks,
Nate

 

[xlbo]

you need to set a reference to ADO in Tools>References within the VBE

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[nslemmons]

Thanks Geoff. That did it.

--Nate