DDE Server

[Pratik Patel]

I launch an Excel application(.xls file with macros that
accepts feeds from DDE server). The DDE server has not
been started because the application(or something else)
will look for this server(.exe file for DDE server) on the
local machine. As soon as the application(.xls file) is
launched, a dialog box appears stating: "Remote data not
accessible. Start application <application>.exe?". And
when you click yes(to start this application.exe file) it
cannot find this .exe file....message stating: "Cannot run
application.exe. The program or one of its components is
damaged or missing." However, nothing is missing and if
DDE server started manually, it will work. By default the
application looks under a particular directory, I need to
know where you can specify information for .xls file to
look for a DDE server .exe file when you launch a .xls
file because all this occurs before any macros are
started?

Thanks,
Pratik

 

[Peter Beach]

Hi Pratik,

You need to put the directory containing the exe in the PATH environment
variable so that Windows can find it. Normally this can be done in the
Control Panel / System Properties / Advanced tab. Select Environment
Variables, click on the Path variable in the system variables, click Edit
and then append (for example) ;c:\MyDDEExe\Server. Do NOT remove any of the
existing entries!

HTH

Peter Beach