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.
Bookmarks