Capture real time data/DDE capture

Hi, i have streaming data coming from DDE.
time format(ex: 9:42:24) in a1, and data in b1.
time in a1 cell increments with every one second and data will change.
sometimes time and data refresh within one second.

whenever time changes in a1,i want capture a1,b1 cells and copy to c1,d1 and next c2,d2.. goes down vertically.
can you write Vb code for this!

Hi Rajre,

In the attached workbook, I have inserted a code in "Sheet1" wherein whenever you change a value in cell A1 it copies the valuesof cells A1 and B1 in columns C and D in consecutive blank rows.

Your are welcome , if this works for you then later on you can mark this thread as Solved from Thread tools.

Also if this solution was helpful you can add to reputation by clicking star* button below the post.

Thanks !!

hi, i have done these steps but data not capturing

----downloaded and opened workbook
----enabled macro

----selected sheet1 A1 cell and pasted DDE link time formula =prortdde|DAX!Time
(after entering formula in A1....... C6 cell got #N/A and D6 cell got xyz)
----selected sheet1 B1 cell and pasted DDE link data formula =prortdde|DAX!Last

now both A1 and B1 are changing for every second but data not capturing!
Am I doing something wrong?

You can try this new attached sheet.

As you have put a formula in cell A1 so this macro runs whenever this worksheet is calculated.
The macro in previous sheet runs whenever the value in cell A1 is changed.

opened and enabled above workbook and after entering the formula in A1....A1 cell got #N/A... instantly a small window came in worksheet like in attached image and i am unable to close that box to enter second formula in B1

if i press 4 times "OK" in that box..A1 changing and 4 rows came in c,d columns like in this image
capture.png

sorry, I left the message box in the code, now it's removed.
The values would copy from cells c2 and d2, please test and let me know.

sorry, I left the message box in the code, now it's removed.
The values would copy from cells c2 and d2, please test and let me know.

attachment

now it is capturing but only A1 cell to both c,d columns
not B1 cell to column d
Image 4.png

again a silly mistake again from my side
corrected file attached

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread