"Tom Sweetland" <email@example.com> wrote in message <firstname.lastname@example.org>... > I just upgraded to windows vista 64 and excel 2007. I am running matlab 2007b. [...] > 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.
Sorry to resurrect that thread, but I've had this very same issue with 2008 and 2009, trying to connect between Matlab and Zemax using the MZDDE toolbox: Matlab 32 bits always works, and Matlab 64 bits works the first time and then cannot "ddeinit" any more (the channel become invalid). It needs to be restarted to work again.
I'm kind of glad to see that someone can reproduce with excel, as Zemax is not a very common piece of software. I also note that a similar bug was reporter in June with 2008b ("1-8K73AV"). The real problem is that mathworks refuses to fix the bug because DDE is obsolete. But to communicate with many professional software in my field, there is only DDE. COM is just not implemented (great "compatibility" thinking from Mathworks).
So if someone had an idea on some voodoo to workaroudn the bug. My only workaround is to install the 32 and 64 bits versions, and use th 32bits when I need DDE.