Put same web query in same cell in each sheet
 

Hi,

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

Thanks very much,
Bertie

--
claytor
-----------------------------------------------------------------------
claytorm's Profile: http://www.excelforum.com/member.php...fo&userid=1161
View this thread: http://www.excelforum.com/showthread.php?threadid=48024

Put same web query in same cell in each sheet
 

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


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=480243