Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE Server
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
DDE Server
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 "Pratik Patel" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
server | New Users to Excel | |||
SQL Server -- Bulk Insert from Excel to SQL Server | Excel Discussion (Misc queries) | |||
Excel 2003 Error Cannot Locate the Internet Server or Proxy Server | Excel Discussion (Misc queries) | |||
problem updating link from Novell server to windows server #REF er | Excel Discussion (Misc queries) | |||
Server name changes | Excel Discussion (Misc queries) |