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

Go to the Office Button / Excel Options / Advanced, and scroll all the way down to the General section.  There you will see the “Ignore other applications that use Dynamic Data Exchange (DDE)” setting checked.  Uncheck the box, click OK to apply, and you’re good to go

.