Specifying table in Excel 2002 web queries
 

Hi,

I've just moved from Excel 2000 to 2002, this has caused some
problems.

I have a workbook containing about 350 sheets, all with the same query.
The only variable parameter is a three letter code in cell a1 of each
sheet which forms part of the url for each query. So the address for
each query is:


http://www.advfn.com/p.php?pid=ukfin...&symbol=LSE%3A["QUOTE0"]

and the three letter code completes the address.

This works just fine in 95% of cases, and the data is returned just as
I want it. However, in some cases the query retrieves information from
a different table. This is because of an inconsistency in the table
numbering in the source data. When I was running Excel 2000 I could fix
this by going into the query paramaters and resetting the table value.

If I navigate with the browser and select the desired table this causes
the address used in the query to become fixed. It is vital that the
query remains dynamic (i.e. the "QUOTE0" bit) in the address for the
effective functionality of the sheet.

Furthermore, I was experimenting with this, and set up a query through
the browser interface directed at a table which one of my dynamic
queries was already successfully returning. This returned the wrong
table of data! This is a recognised problem - Microsoft states data
cannot be queried from dynamically scripted tables, cf
http://support.microsoft.com/kb/277899/en-us. But, that is not the
case, as my successful dynamic query on the same data shows.

*So, how can I set the table value without having to do so through the
browser interface?* That would seem to be the most logical solution to
my problem.

I never had these problems with Excel 2000, and I have had other
problems migrating my spreadsheets to 2002. Has anyone else experienced
similar difficulties?

Thanks for any help, it really is appreciated.

Bertie


--
claytorm
------------------------------------------------------------------------
claytorm's Profile: http://www.excelforum.com/member.php...o&userid=11610
View this thread: http://www.excelforum.com/showthread...hreadid=566651