SQL Connection
Hi All,
I want to have the code for .Connection = ???? to
represent ActiveWorkbook sheets("Temp 1")in the following
part;
With Sheets("TempData").Range("a1").QueryTable
.Connection = ????
.CommandText = myCmd
.Refresh BackgroundQuery:=False
End With
Thanks,
Adul
|