Run Time Error 1004: Application-Defined or Object-Defined Error
What values do you get if you
MsgBox sSql
MsgBox sConn
before
==Here is where the error is happening:
Set oQt = sh.QueryTables.Add(Connection:=sConn, _
Destination:=sh.Range("A8"), _
SQL:=sSql)
--
urkec
|