Web Query & Array Questions!

[gr8guy]

Hi,

I have a few questions:

1] Is it possible to have 2 or more web queries (.iqy files) run in a
single worksheet?

2] How do i get an ever changing web query data received on worksheet
(dynamically changing rows & columns) into an Array say Old_Array. I think
it has to do with resizing data & also preserving array data once data is in
array.

3] How to get new data on REFRESH into a new array variable, say
New_Array & then compare this data with Old_Array variable.

4] How to find whether new data is really new & find missing elements of
Old_Array & then dump missing elements into worksheet2-1st column, with time
missing ( i suppose Now() ) in worksheet2 - 2nd column.

5] How to get a Count of no of times the same elements were present OR
missing after each refresh.

Can Anybody help me with this?

Rgds,

Eijaz

 

[Dick Kusleika]

Eijaz

You can have two queries in a worksheet, no problem. As for the rest, it
sounds like using another worksheet to "post" the data you want to track,
then do whatever kind of analysis you need on that worksheet would work the
best. Have a look here

http://www.dicks-blog.com/excel/2004/08/graphing_web_da.html

and see if that doesn't get you close to what you want.