Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Link a cell of a sheet to a Query Criteria in EXCEL 2007 | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same Excel Workbook? | Excel Discussion (Misc queries) | |||
Anyone Else Use Database Query to Query Another Sheet in the Same | Excel Discussion (Misc queries) |