Refresh Modified Query From Same Sheet
 

Hi All,

How can I refresh a (modified thru code based on value
from sheet1) query from another sheet from the workbook?

I want to have the code for .Connection = ???? to
represent activeworkbook sheeets("Temp 1")


With Sheets("TempData").Range("a1").QueryTable
.Connection = ????
.CommandText = myCmd
.Refresh BackgroundQuery:=False
End With


thanks All

Abdul