Categories
Excel 2007 Microsoft Office

There was a problem sending the command to the program: Excel 2007 Error

If you’re getting the following error message when opening an Excel 2007 file in Windows 7 (only when there’s no Excel window currently open in your system), then do the following in order to fix it.

There was a problem sending the command to the program
There was a problem sending the command to the program
  • Click the Microsoft Office Button, and then click Excel Options.
  • Click Advanced, and then click to clear the “Ignore other applications that use Dynamic Data Exchange (DDE)” check box in the General area.
Ignore other applications that use Dynamic Data Exchange (DDE)
Ignore other applications that use Dynamic Data Exchange (DDE)
  • Click OK.
  • If the “Ignore other applications that use Dynamic Data Exchange (DDE)” check box is already unticked then tick it then Click OK.
  • Close Excel
  • Reopen Excel
  • Click the Microsoft Office Button, and then click Excel Options.
  • Click Advanced, and then click to clear the “Ignore other applications that use Dynamic Data Exchange (DDE)” check box in the General area.
  • Click OK.
  • Go to Start -> Run -> regedt32.exe

run_regedt32

  • Go to “HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open” and export and save the “ddeexec” key.

backup_ddexec

  • Go to “HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open” and delete the “ddeexec” key.

delete_ddexec

  • Reboot your machine.

 

Categories
Software Video Conversion

DVR-MS to DivX Conversion

Windows Media Center encodes its recording to DVR-MS (Microsoft Digital Video Recording). It’s video is encoded using the MPEG-2 standard and audio using MPEG-1 Layer II or Dolby Digital AC-3 (ATSC A/52). The result is high quality video with top quality audio to match. Only one problem, quality comes at a hefty price.

One minute of audio/video footage takes up about 116,521 kB (113 MB) of space! Considering that an average movie is about 90 minutes long, it would require at least 10,241 MB (10 GB) of storage to store one movie. So with my 1TB hard drive, I could store a measly 100 movies. Now that’s just ridiculous! I guess Microsoft doesn’t want to encourage TV recording through Windows Media Center. That’s the only conclusion I can come up with because there are loads of other trusted high quality standards that they could have used to encode video/audio. Like DivX.

MCEBuddy Website ThumbnailLuckily for us, there’s a useful utility that we can use to convert DVR-MS to DivX. The software is called MCEBuddy. MCEBuddy takes your LARGE DVR-MS television recording files and makes them small by converting to another format saving you disk space. I’ve searched high and low for a utility or script that converted DVR-MS to another format successfully. MCEBuddy is by far the best software for the job. Visit MCEBuddy website http://mcebuddy.com/.