VBA: Error "No value given for one or more required parameters"

[FryGirl]

I found a workbook which runs an ADODB connection just fine. I'm now rebuilding a workbook to my specs, but the same code which runs on the first workbook will not run on the second.

I get the error, "No value given for one or more required parameters" and it debugs on

Dim sSQL        As String

​

Set RecSt3 = New ADODB.Recordset

sSQL = "SELECT * FROM [A4:B100] where (MemberName is not null and (MemberName=ReportTo));"

RecSt3.Open sSQL, ExcConn, adOpenKeyset

I've checked the tools - references in the VBE and seem to have what is needed. Doing some online research, it said I should have Microsoft ActiveX Data Objects 6.1 and that is checked.

The table is as below. Starts on A4 with the header and column B is just set to a large number.

MemberName	ReportTo
CC	CC
CCF	CC
CCQ	CC
FSC	CC
FSCA	FSCA
FSCN	FSCA
FSD	CC
FSDA	FSDA
FSDE	FSDA
FSDL	FSDA
FSDP	FSDA

 

[JustynaMK]

Hi,

Can you try running the same code but only for:
"SELECT * FROM [A4:B100]"

See if that part works for you.

 

[FryGirl]

Hi JustynaMK,

Turns out I'm scrapping the idea of a recordset and have moved in a different direction. Thank you helping out.

 

[JustynaMK]

No worries! Didn't help at all but I'm glad you're progressing take care.