View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Basta1980 Basta1980 is offline
external usenet poster
 
Posts: 102
Default Refer to a different worksheet


Hi there,

I have this code

With ActiveSheet.QueryTables.Add(Connection:= _
"OLEDB;Provider=Microsoft.Office.List.OLEDB.1. 0;",
Destination:=Range("A1"))

What I need is a code that doens not refer to the active sheet but to a
sheet with name TimeToImplement cell A1. How do I go about?!

Regards,

Basta1980