links between workbooks in different instances

E

excel_new

Hi, Guys, is it possible to establish links between two
workbooks if they are in different excel instances? What
I want to do is to set up a DDE link in one book to read
in dynamic data and in another workbook, I set up cell
formula pointing to the first book. I have tried to use
VB's getObject function to get a handle of the first
workbook, but I can only get static data in the second
book, i.e. the cells in the second book are not updating.
Thanks in advance.
 
G

Guest

-----Original Message-----
Hi, Guys, is it possible to establish links between two
workbooks if they are in different excel instances? What
I want to do is to set up a DDE link in one book to read
in dynamic data and in another workbook, I set up cell
formula pointing to the first book. I have tried to use
VB's getObject function to get a handle of the first
workbook, but I can only get static data in the second
book, i.e. the cells in the second book are not updating.
Thanks in advance.
.
Click to expand...

Sorry, I did not notice somebody had asked similar
question before. And Tom's answer works for me. Just a
reminder to newbie like me, do not forget to turn on the
option "update remote reference".:)
 
Top