Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE and scrolling
Hi
I'm pulling realtime stock data into Excel 2002 by DDE populating each next lower row with the latest data. In other words the column length is constantly increasing. The application sets up an array to a requested size (of N rows) and populates it with all #N/A. The incoming data then replaces these #N/As sequentially, top down. What I would like to achieve is to set an array (of N rows) where the newest data is written to the bottom row and the top row is deleted. The array thus remains the same size showing only the last N latest updates. (Latest on bottom row, oldest on top row). Any VBA help would be much appreciated leshik |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE and scrolling
Hi,
I not sure how you have you feeds and arrys set up so these suggestion might be poor, but just some thoughs. you could put the first arry into another arry of the same size, but only load the fist one in from the second data set, and "fill" it with the new data. but from what you have said, i would just delet a row (at the top of the table and insert you new data into the next row. - this seem to obvious so i guess i missing somthing. good luck ross |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE and scrolling
Did you solve this problem? I'm trying to do the same thing. -- Otto "leshik" wrote: Hi I'm pulling realtime stock data into Excel 2002 by DDE populating each next lower row with the latest data. In other words the column length is constantly increasing. The application sets up an array to a requested size (of N rows) and populates it with all #N/A. The incoming data then replaces these #N/As sequentially, top down. What I would like to achieve is to set an array (of N rows) where the newest data is written to the bottom row and the top row is deleted. The array thus remains the same size showing only the last N latest updates. (Latest on bottom row, oldest on top row). Any VBA help would be much appreciated leshik |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel- smooth scrolling (instead of 'snap' scrolling) | Setting up and Configuration of Excel | |||
Vertical scrolling...jumps rather than smooth scrolling | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta | Excel Discussion (Misc queries) | |||
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 | Excel Discussion (Misc queries) | |||
scrolling - help | Excel Discussion (Misc queries) |