Invoking macro to insert rows according to DDE imported data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chainastole - 29 May 2007 16:24 GMT

There is a DDE compatible stream of data. I want this data be inserted (row
insertion) at the top of the worksheet each time the imported data is
different from that stored in the worksheet. The beneath rows should be
shifted 1 row down, thus making some sort of shift register with most recent
data on top, less recent below, etc.
How may I do that?

Reply to this Message

JLatham - 02 Jun 2007 01:49 GMT

Short answer:
You are going to have to capture the information as it comes in, then
compare it with existing data on the sheet to see if it is different. If it
is different, then you simply use a line of code like
Range("A1").EntireRow.Insert
which will push all the older data down 1 row. Then place the captured data
into the newly created row. We're talking about some VBA coding here,
obviously.

The details of doing all of this depend on how things are being done with
your DDE stream now. Since I am DDE-ignorant, I've stayed out of this
discussion for 3 days, because you're going to probably ask "how do I do what
you said", and because I don't know how things are working at your end right
now, I don't have an answer for that.

> There is a DDE compatible stream of data. I want this data be inserted (row
> insertion) at the top of the worksheet each time the imported data is
> different from that stored in the worksheet. The beneath rows should be
> shifted 1 row down, thus making some sort of shift register with most recent
> data on top, less recent below, etc.
> How may I do that?

Reply to this Message