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