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