Web Queries from different sheets

Hi, I wrote a Macro that runs two different web queries. What I need to do is
make them work on different sheets.

Here's part of it:

'Dim strCnn As String
strCnn = "URL;" & Range("B6").Text
With ActiveSheet.QueryTables.Add(Connection:=strCnn,
Destination:=Range("B10"))
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True

I want this one to work on a specific sheet, not the activsheet!

Many thanks,
Alex

With ActiveSheet.QueryTables.Add(Connection:=strCnn, _
Destination:=Worksheets("Data6").Range("B10"))


--
Regards,
Tom Ogilvy


"Alex Martins" <Alex Martins@discussions.microsoft.com> wrote in message
news:DC8CFBFE-D157-4226-94C0-28A2A56E122C@microsoft.com...
> Hi, I wrote a Macro that runs two different web queries. What I need to do
is
> make them work on different sheets.
>
> Here's part of it:
>
> 'Dim strCnn As String
> strCnn = "URL;" & Range("B6").Text
> With ActiveSheet.QueryTables.Add(Connection:=strCnn,
> Destination:=Range("B10"))
> .FieldNames = True
> .RowNumbers = False
> .FillAdjacentFormulas = False
> .PreserveFormatting = True
>
> I want this one to work on a specific sheet, not the activsheet!
>
> Many thanks,
> Alex

Thank you very much for your answer. It works perfectly!
Alex

"Tom Ogilvy" wrote:

> With ActiveSheet.QueryTables.Add(Connection:=strCnn, _
> Destination:=Worksheets("Data6").Range("B10"))
>
>
> --
> Regards,
> Tom Ogilvy
>
>
> "Alex Martins" <Alex Martins@discussions.microsoft.com> wrote in message
> news:DC8CFBFE-D157-4226-94C0-28A2A56E122C@microsoft.com...
> > Hi, I wrote a Macro that runs two different web queries. What I need to do
> is
> > make them work on different sheets.
> >
> > Here's part of it:
> >
> > 'Dim strCnn As String
> > strCnn = "URL;" & Range("B6").Text
> > With ActiveSheet.QueryTables.Add(Connection:=strCnn,
> > Destination:=Range("B10"))
> > .FieldNames = True
> > .RowNumbers = False
> > .FillAdjacentFormulas = False
> > .PreserveFormatting = True
> >
> > I want this one to work on a specific sheet, not the activsheet!
> >
> > Many thanks,
> > Alex
>
>
>