DDE Server/Excel 97

P

Pratik

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top