Monday 24 October 2011

Solution: Resetting TCP / IP Stack on Windows PC

Below solution is worth a try when you see your computer not connecting to the network even though there is nothing wrong with the cabling and the hardware. Sometimes it is necessary to refresh settings of your networking hardware for it to get going as normal again.

Use netsh utility. Follow the steps below.You must be logged on to the computer as an administrator. The first method uses a Fix it automated solution to reset TCP/IP.

  1. At the command prompt, copy and paste (or type) the following command and then press ENTER:
    netsh int ip reset c:\resetlog.txt
    Note If you do not want to specify a directory path for the log file, use the following command:
    netsh int ip reset resetlog.txt
  2. Reboot the computer.
When you run the reset command, it rewrites two registry keys that are used by TCP/IP. This has the same result as removing and reinstalling the protocol. The reset command rewrites the following two registry keys:
SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\ 
SYSTEM\CurrentControlSet\Services\DHCP\Parameters\

To run the manual command successfully, you must specify a file name for the log, in which the actions thatnetsh takes will be recorded. When you run the manual command, TCP/IP is reset and the actions that were taken are recorded in the log file, known as resetlog.txt in this article. 
Reference: Microsoft 

Wednesday 19 October 2011

Solution: Deleting Sent Emails from Recepient's Mailbox

Open sent Items in MS Outlook

Open email that needs recalling

Click on

Other Actions --> Recall this message

  • Select "Delete Unread copies of this message"  
  • Tick "Tell me if recall succeeds or fails for each receipient"
  • Press OK

After this, keep monitoring your mail box and you will see all the ones that have been recalled and also the ones that cannot be recalled.

Tuesday 18 October 2011

Solution: Windows Updates not working

To register the Wups2.dll file in Windows, follow these steps:

Step 1: Stop the Automatic Updates service. To do this, follow these steps:

a. Open the Command Prompt window. To do this, click Start, click Run, type cmd, and then click OK.
b. At the command prompt, type the following command, and then press ENTER:
net stop wuauserv

Step 2: Register the Wups2.dll file. To do this, follow these steps:

a) At the command prompt, type the following command, and then press ENTER:
regsvr32 %windir%\system32\wups2.dll

Note For a computer that is running Windows XP Professional x64 Edition, type the following command, and then press ENTER:
regsvr32 %windir%\syswow64\wups2.dll

b) Click OK if you receive a verification message.


Step 3: Start the Automatic Updates service. To do this, type the following command at the command prompt, and then press ENTER:
net start wuauserv


Step 4: Exit the Command Prompt window. To do this, type exit at the command prompt, and then press ENTER.

You should now be able to run Windows Updates on your PC.

Solution: Open and convert .WPS files

Step 1: Download Microsoft Works 6–9 File Converter.
Step 2: Install it
Step 3: Open the .wps file or document
Step 4: Save as latest format document to avoid future compatibility issues

Solution: Updating Global Address List Forced on MS Exchange 2008

Logon to MS Exchange Management Console. Fire following commands one by one

  • Get-GlobalAddressList | Update-GlobalAddressList
  • Get-AddressList | Update-AddressList

Solution: Crack Excel Spreadsheet Password Protection

Open the workbook that has the protected sheet in it. Hit Alt+F11 to view the Visual Basic Editor. Hit Insert-Module and paste this code into the right-hand code window:

Sub PasswordBreaker()
'Author unknown but submitted by brettdj of www.experts-exchange.com

Dim i As Integer, j As Integer, k As Integer
Dim l As Integer, m As Integer, n As Integer
Dim i1 As Integer, i2 As Integer, i3 As Integer
Dim i4 As Integer, i5 As Integer, i6 As Integer

On Error Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 126


ActiveSheet.Unprotect Chr(i) & Chr(j) & Chr(k) & _
Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & Chr(i3) & _
Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
ActiveWorkbook.Sheets(1).Select
Range("a1").FormulaR1C1 = Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next


End Sub


Close the VB Editor window. Navigate to the worksheet you want to unprotect. Hit Tools-Macro-Macros and double-click PasswordBreaker in the list.

Note: If you have multiple worksheets in the Excel Workbook, and they all are password protected, you will have to run this macro on each one of them by selecting them individually.