Date: May 15, 2009 1:13 PM
Author: Tom Sweetland
Subject: DDE interface problem with excel 2007 - 64 bit system

I just upgraded to windows vista 64 and excel 2007. I am running matlab 2007b. 

I have a script that writes cells from matlab similar to below:

chan=ddeinit(chan,'Excel','Sheet1')

for i=1:1000;
      a=ddereq(chan,'r1c1',[1 1],3000)
      ddepoke(chan,'r2c1',2);
end

ddeterm(chan)

I can run this script once or twice, but ultimately it refuses to execute the ddeinit line correctly. I have to exit matlab and restart for it to work again and this isn't always consistent - sometimes i have to restart the entire computer. 

I haven't had any similar problems running xp 32 with excel 2007 and matlab2007b in the past.

Any ideas would be appreciated.