Please make sure you have declared channel variable and Excel is running when you open a new DDE channel and it knows what "test.xls" is. By the way which Excel version are you using? : I am not able to make DDE-client functions working on a Win 2k machine with : 24x7 Scheduler v. 3.4.11. : The DDEOpen function always works, returning a positive channel number, but : when I try to use this channel to make : execute/setdata/getdata operations a failure message pops up after a 1-minute : timeout ("DDE error. Request denied"). : Also this minimal example doesn't work: Dim channel, number : DDEOpen "Excel", "test.xls", channel : DDEClose channel : the close statement fails with a generic "DDE error. Close channel : failed". : I have made my trials with the debugger and the JAL script is not : "asyncronous", is inserted in the "[default]" queue : and the priority is "Normal". : What am I doing wrong? : Thanks for any help.
|