VIPUL IT

In a scenario where you have physically removed hardware from a machine you can no longer see it in device manager.  This does not mean that it is gone.  Evidence of that is, if for example you had a network card that had a Static IP address set and you remove the card and add a new one then try to set the IP address to the same as the old NIC you will get an error message. The error might look something like “The IP address 192.168.30.100 you have entered for this network adapter is already assigned to another adapter (Microsoft Virtual machine Bus Network Adapter #3) which is no longer present in the computer.  If the same address is assigned to both adapters and they both become active, only one of them will use this address.  This may result in incorrect system configuration”.  In Windows Server 2008 R2 and Windows 7 it actually gives you an opportunity to “remove the static IP configuration for the absent adapter”. If you say Yes, this will eliminate the ...

How to unprotect Excel sheet without password Unlock Excel spreadsheet with VBA code (for Excel 2010 and lower) If you are using Excel 2010 or older version, you can unlock a password-protected sheet with the following macro. Press  Alt + F11  to open the Visual Basic Editor. Right-click the workbook name on the left pane ( Project-VBAProject  pane) and select  Insert  >  Module  from the context menu. In the window that appears, paste in below code. Sub PasswordBreaker()      'Breaks worksheet password protection.        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   ...