Error in Excel - when attempting to open

There was a problem sending the command to the program

Problem Statement:

When you double-click an Excel workbook or a shortcut to an Excel workbook, Excel starts.

But, the Excel workbook does not open, and you receive an error message.

        “There was a problem sending the command to the program" 

Solution:

To fix this issue we have to: Turn off the “Ignore other applications that use Dynamic Data Exchange (DDE) setting”

Automated Solution:

To automatically solve this problem in Excel, Download and run the below SolutionScript by double clicking it. 

                                                           Download: SolutionScript

Manual Steps:  Microsoft Excel 2010 and 2013

1.   Click the File tab, and then click Options.
2.   Click Advanced, scroll down to the General section, and then
3.   Uncheck the Ignore other applications that use Dynamic Data Exchange (DDE) check box.
4.   Click OK.

            J Issue fixed    J

                                       !.... Any Queries, Please post it in comments....!

Remove Shortcut Virus in Pendrive

Solution to Remove Shortcut Virus in Pen drive/Memory cards completely

Issue:
All your folders in the pen drive/memory cards are converted into shortcut icons.

Solution:

Follow the below steps to remove this virus completely without using any antivirus software.

Step 1 - Un-Hides the hidden folders and virus (.vbs extension file)

• Go to Start à Run à type cmd and click ok.
• attrib -h -r -s /s /d e:\*.*
• Copy the above command and Right click in command prompt window to paste the copied text.
• Replace e with your drive letter.

Press Enter, now you can check for your files and folder in the Pen Drive.

Step 2 - Select all and shift delete

• Open the Pen drive
• Enter *.vbs in search box to search the virus file.
• If found make a note of the file name.
• Select all the files & folder and shift delete.

Now Virus is removed from the pen drive but if you unplug and insert the pen drive, Virus will get into your pen drive again.

HOW & WHY..?

Because virus will be hosted in computer’s temporary memory and affects the wscript.exe windows file.

When you insert the pen drive wscript.exe executes the virus file hosted in temp memory

So two things you should do to remove virus completely

1. Clear the temp files
2. Delete the affected wscript.exe file

Step 3 - Remove completely from system

• Unplug the Pen drive
• If you know the name of virus file then follow step the 3.1 else follow 3.2

  Step 3.1 - Clears registry

• Go to Start à Run à type regedit and click ok.
• Search the virus.vbs in the regedit window and delete it.
• Replace virus with name of the virus file

  Step 3.2 - Clears Temp File

• Go to Start à Run à type %temp% and click ok.
• Select all and shift delete

Step 4 - Delete the affected wscript.exe windows file

• File location (Windows 7): C:\Windows\System32\wscript.exe
• Select the wscript.exe file and delete it
• Restart the system

J  Shortcut virus removed completely from your system and pen drive  J

Tips: 

ü  After Buying the Pen drives/Flash Drives/USB's/Memory Cards Format it.

ü  Scan the pen drive regularly with antivirus software

ü  Create a Folder with name AUTORUN.INF and press enter.

ü  Why we need to create the AUTORUN.INF folder means, the virus mainly contains notepad file with the name autorun.inf.

ü  So, if u create the folder with autorun.inf, the virus notepad file cannot enter into the Flash drive/Pen drive because already with that name a file is existed as created in the Pen Drive.

               !---- If you have any questions please post it in comments ----!