Please post all of your code... When you look at your recordset (rs) is there
anything in it?
--
HTH...

Jim Thomlinson


"bmolintas" wrote:

I added the reference and am no longer receiving the error but clicking the
button does not pull down any recrods to the spreadsheet.

"Jim Thomlinson" wrote:

Did you make a reference to "Microsoft ActiveX Data Objects ?.? Library"
Tools - References in the VBE
You need that if you want to use ADODB
--
HTH...

Jim Thomlinson