Can I refresh more than 1 external (web) query data at once?

[deniseandgavin]

My sheet has a number of queries that look at the web to return tables
of share prices. I use this statement


Worksheets("Data").Range(B1).QueryTable.Refresh

for each stock.

I would like to run all the queries at once rather than looping
through each one - in an effort to speed it up.
Can it be sped up? What might the code look like?

Thanks

Gavin

 

[deniseandgavin]

My sheet has a number of queries that look at the web to return tables
of share prices.  I use this statement

Worksheets("Data").Range(B1).QueryTable.Refresh

for each stock.

I would like to run all the queries at once rather than looping
through each one - in an effort to speed it up.
Can it be sped up?  What might the code look like?

Thanks

Gavin

I forgot to mention that B1 changes for each stock - say B15, B25, B35
etc

 

[Don Guillett]

Perhaps a better way to do this would be to have ONE query with a looping
macro using a variable and exporting the data to another area for use as
desired.