Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query & Array Questions!
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Web Query & Array Questions!
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...ng_web_da.html and see if that doesn't get you close to what you want. -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "gr8guy" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS query - 2 questions | Excel Discussion (Misc queries) | |||
Query questions (I think) | Excel Worksheet Functions | |||
Array questions | Excel Programming | |||
Listbox and Array questions | Excel Programming | |||
Array Questions | Excel Programming |