Activate sheet and QueryTables.Add

[AMAS]

I am attempting to weed out the activate sheet events from code. I use the QueryTables.Add to open a web page in Excel. It doesn't seem to work unless I first activate the worksheet and then use ActiveSheet instead of the sheet name. Is this the way it is supposed to be?

Example (works):

Worksheets("Temp").Activate
  
' Import web query
  With ActiveSheet.QueryTables.Add(Connection:= _
    "URL;" & MyWebPage _
    , Destination:=Range("$A$1"))

Example (doesn't work):

' Import web query
  With Worksheets("Temp").QueryTables.Add(Connection:= _
    "URL;" & MyWebPage _
    , Destination:=Range("$A$1"))

Example (doesn't work):

Worksheets("Temp").Activate
  
' Import web query
  With Worksheets("Temp").QueryTables.Add(Connection:= _
    "URL;" & MyWebPage _
    , Destination:=Range("$A$1"))

AMAS

 

[AlphaFrog]

Try this...

[COLOR="Green"]' Import web query[/COLOR]
  With Worksheets("Temp").QueryTables.Add(Connection:= _
    "URL;" & MyWebPage, Destination:=[COLOR="Red"]Worksheets("Temp").[/COLOR]Range("$A$1"))
    .Refresh
  End With

 

[AMAS]

Thanks AlphaFrog. That was exactly the part I was missing.

AMAS