Put same web query in same cell in each sheet

[claytorm]

Hi,

I have a workbook with multiple sheets, each containing stock data for a different company. I have a general web query, the only changeable parameter which forms part of the web address used in the query is the three letter company identifier in a1 of each sheet. I want to put the same web query in cell a2 of each sheet. I have the web query saved as an iqy file. Is it possible to do this programmatically?

Thanks very much,
Bertie.

[Leith Ross]

Hello Bertie,

Could you tell me a little more about the data? Do you need to append or insert the data in A1 to the query in A2? Could you post and example of what you want to do?
It would help me better understand your needs.

Thanks,
Leith Ross

[JONYV]

Hi Bertie,

I know this topic is an old one, but I have the same problem as you once had. Did you find a solution?
(You can say it here or PM it me if you want )

Thanks a lot!

[arlu1201]

Jonyv,

This is a 8 yr old thread and not likely to get any responses. Its better you start your own thread.