Efficient Data Transfer Between Two Open Sessons of Excel

Efficient Data Transfer Between Two Open Sessons of Excel

I have two sessions of Excel open… Workbooks A in session 1 and B in session 2. Workbook B needs to run by itself since it is using DDE to bring data in from a third party and can not be encumbered by any resource strain, e.g. calculations. Once data has been properly ported into Workbook A, I need to immediately, within a few milliseconds, port the data to Workbook B where some intensive number crunching takes place. Form a resource perspective, this arrangement reaches a good balance.
The challenge is to find the most efficient way of making this transfer of data by crossing over the border from one open session of Excel to another.
I am using Excel 2010, Windows 7 Pro, 64bit. Some trial and error work was done with the following with no luck probably because I am not that famaliar with the protocols:
1) DAO
2) ADO
3) DDE
I am looking for some out-of-the-box solution here that is simple and effective.

If you want something simple and effective, please provide helpers with a posted example according to those same criteria....

Attached are two files demonstrating the task.

Bump No Response

Bump No Response

I think the simplest way is to copy the range that contains the DDE-link, and use pastespecial in your Workbook B, paste link.

So the result in workbook B will be like

PHP Code: 

=[__Query1.xls]Blad1!C4 


Now workbook B will be a realtime copy of workbook A.(in my example __Query1.xls)