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