Tuesday, March 27, 2012

there was a problem sending the command to the program

Consider the following scenario:

You double-click a Microsoft Excel workbook in Microsoft Windows Explorer

or

You double-click a short-cut to an Excel file located on your desktop or any other location

The Microsoft Excel application starts, but the Excel file does not open and you receive an error message.
The error message may be different depending on the version of Windows you are using.

In Windows 7, you may see this error message:
There was a problem sending the command to the program.

In Windows Vista, you may see this error message:
Windows cannot find 'FilePath\FileName', Make sure you typed the name correctly, and then try again.

In Windows XP, you may see this error message:
Cannot find the file 'path' (or one of its components). Make sure the path and filename are correct and that all required libraries are available.

There was a problem sending the command to the program.


CAUSE

This problem may occur if the Ignore other applications that use Dynamic Data Exchange (DDE) setting in Excel is selected.

RESOLUTION

To have us fix this problem for you in Excel 2010, Excel 2007 and Excel 2003, go to the "Fix it for me" section. If you would rather fix it yourself or you have a version Excel prior to 2003, go to the "Let me fix it myself" section.



Fix it for me

To fix this problem automatically on Excel 2010, Excel 2007 or Excel 2003, click the Fix this problem link. Then click Run in the File Download dialog box, and follow the steps in this wizard.
Fix this problem
Microsoft Fix it 50392

Note This wizard may be in English only; however, the automatic fix also works for other language versions of Windows.

Note If you are not on the computer that has the problem, you can save the automatic fix to a flash drive or to a CD, and then you can run it on the computer that has the problem.

Let me fix it myself

To resolve this problem yourself, follow the steps for your version of Microsoft Excel:


Microsoft Excel 2010
  1. Click the File tab, and then click Options.
  2. Click Advanced, and then click to clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box in the General area.
  3. Click OK.
Microsoft Office Excel 2007
  1. Click the Microsoft Office Button, and then click Excel Options.
  2. Click Advanced, and then click to clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box in the General area.
  3. Click OK.
Microsoft Office Excel 2003 or earlier versions of Excel
  1. Click Options, on the Tools menu.
  2. Click the General tab.
  3. Click to clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box, and then click OK.
After you do this, you should be able to open workbooks by double-clicking them in Windows Explorer.

MORE INFORMATION

When you double-click an Excel workbook in Windows Explorer, a dynamic data exchange (DDE) message is sent to Excel, instructing it to open the workbook that you double-clicked.

If the Ignore other applications that use Dynamic Data Exchange (DDE) setting is selected, Excel ignores DDE messages sent to it by other programs. As a result, the DDE message sent to Excel by Windows Explorer is ignored, and Excel does not open the workbook that you double-clicked.

http://support.microsoft.com/kb/211494

No comments:

Post a Comment