February 20, 2013

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

If you have ever tried to open an excel document and received the error that says "There was a problem sending the command to the program", you can fix it by doing the following:

1. Open Excel 2007
2. Open the Menu on the top left
3. Click the "Excel Options" button


4. Click the advanced tab on the left of the options screen
5. Under the general options un-check the box "Ignore other application that use Dynamic Data Exchange (DDE)"

How to Bridge an Internet Connection

Wireless has taken a huge leap in usage thanks to a huge improvement in its usability over the years. That's good for many portable devices such as laptops, smart phones, etc. But for people using desktops, a wireless adapter may not be included. Or, you may want to have a more stable wireless connection than the one you currently have.
Bridging an internet connection refers to making connections between different ports that will be used by your computer, such as Ethernet and wireless. Shown in this article are simple steps that you can use to create your own bridged connection.

1 ) Make sure the relevant machines and crossover cable are working. 
To see if the cable is working, plug it into both machines. If the port lights up, then you know that it works. If it does not light up, the cord is not in working order.

2) Get started. 
On both machines, go the the start menu, open the control panel and go to "Network and Internet". The Local Area Connection (LAN) should show up with no internet access in the window.


3) Create the bridge on the host machine.
Go to "Change adapter settings" on the left pane on the host machine. Two or more connections should show up. Highlight both Local Area Connection and Wireless Network Connection. Right click one of the icons you highlighted and an options menu should come up with only "Bridge Connection". Click it and it should take a second to set up the connection.


The bridge is already working? Some machine cards will automatically assign the needed network information for you. If it does, an icon on the client machine's task bar will show up with a monitor and a fork like plug showing beside it. If the icon has a caution sign, it means that the information needs to be assigned manually.

4) Do error checking. 
A new icon should show up in the window called "Network Bridge" and it should display the name of the wireless network you are connected to below "Network Bridge". If not, repeat step 3 to remove the bridge and restart the process.

5) Access the command line. 
Still on the host machine, open the start menu and in the search bar type "CMD". Open Notepad and be prepared to write down your network information.

6) Get the machine's network information. 
In the CMD window, type "ipconfig /all". A large list of information should show up. Scroll to the top and look for "Ethernet adapter Network Bridge:", copy the IPv4 Address, Subnet Mask, Default Gateway, and the DNS Servers


7) Perform a client machine setup. 
On the client machine, click on "Local Area Connection". A window should pop up called "Local Area Connection Status"; select Properties, and in that window double click "Internet Protocol Version 4 (TCP/IPv4)".

8) Enter the IP information. 
To enter the network information, select "Use the following IP Address". Now the three bars should be lit up. In the IP address row, enter the IPv4  address of the host machine, and  in the last section of numbers increase it by  1.
Example: 192.168.1.179 becomes 192.168.1.180. The Subnet Mask is the same as what was copied as with the Default Gateway.

9) Check the DNS servers. 
The DNS servers will also be changed to what was copied down from the host machine's network information. For the first row, enter the information as it was from the Host, and in the second row put in the same number but increase the last number by 1.
Example: 192.168.1.1 and 192.168.1.2.

10) Finalize the connection.  
Click the box about Validating Settings upon exit and click OK. It will take a second to validate but the connection should start working a few seconds after clicking OK. Your new connection should be working now.






February 6, 2013

Error: Windows Explorer has stopped working

1) Run System File Checker (CFS) to check yours Files

Use System File Checker to scan your PC for missing or corrupt files. To do this, follow these steps:

1. Click Start, and then type cmd in the Search box.2. In the results area, right-click cmd.exe, and then click Run as administrator. You may be prompted to type the password for an administrator account.
3. Click Continue if you are the administrator or type the administrator password and then, click Continue.
4. At the command prompt, type Sfc /scannow and then press ENTER.

2) Test your system's RAM memory


Sometimes Faulty RAM (Random-Access Memory) can cause intermittent problems within Windows. Use the Windows Memory Diagnostics Tool by clicking Start, type Memory Diagnostics and select the result in the list. When the Windows Memory Diagnostics Tool window appears, choose Restart now and check for problems (recommended).

3) Test for picture files that may contain Corruption

Corrupt images can sometimes issues with Windows Explorer. If Windows Explorer stops working while working with pictures or browsing folders that contain pictures, there may be corruption is one or more picture files. To test for this issue, follow the steps below:

1. Click Start and click Computer
2. Click Organize and select Folder and search options from the dropdown
3. On the Folder Options window, click the View tab
4. Place a check in the option to Always show Icons, never thumbnail
5. Remove the check for the option to Display file icon on thumbnails
6. Click OK to close the Folder Options window

Now, go to any folders that contain Pictures or Videos and see if you can reproduce the issue. If Windows Explorer does stop working, the folder that you were viewing possibly contains one or more pictures files that are corrupt or contain corrupted thumbnail data.

Note: After adjusting the options to Display file icon on thumbnails, and Always show Icons, never thumbnail, files no longer display thumbnails so pictures and other files will display as the default icon for their file types. If you can reproduce the error with these options set, the issue is not with pictures or videos and you should return the Folder options to their original settings.

Check the details of the error to see which application caused Windows Explorer to stop working. To do this, follow these steps:

1. Click Start and type Action Center in the Search area and click Action Center from the returned list
2. In the Action Center window, click Maintenance, click View reliability history 
     and then click View all  problem reportsfrom the bottom of the Reliability Monitor window
3. Scroll down to the list of Windows Explorer items
4. Double-click on Stopped working to view technical details and then make a note of the technical details.

Love

 Once upon a time in a picturesque town nestled in the rolling hills, there lived a young artist named Lily. She was known throughout the co...