In Excel you can use the allmighty Visual Basic Editor to create very useful macros. Today I will share with you a macro which deletes a row if it contains some string. The code is
Sub delgoogle()
Dim i As Long
With ActiveSheet.UsedRange
For i = .Row + .Rows.Count – 1 To .Row Step -1
If Cells(i, “A”).Text Like “*google*” Then Rows(i).Delete
Next i
End With
End Sub
What this code does, is look in the sheet where the macro is ran, for a row containing the word google. Note the “*” which means that the row can be …

Windows 7 networking navigation just like Vista sucks big time.  If you are wondering how to see a folder shared from VirtualBox, then the answer is you can’t do it directly like in XP going to Virtual Box Shared folders, because that thing does not exist. I’ve found out that you need to navigate to the shared folder by entering in the address bar
\\vboxsvr\<share>
Where <share> is the name you have used when sharing the folder within VirtualBox.

This error is quite common nowadays on computers with Firewalls.The error is described by Microsoft as
ERROR_INTERNET_CANNOT_CONNECT
This issue can be caused by:
- Internet Proxy being blocked by some Firewall
- Bad bad bad configuration of Firewall
- You have very outdated BITS service
- You are using some download accelerator
- Check if the network cable is plugged (no wifis)

When you paste or import text that looks like a hyperlink into a cell, the hyperlink does not actually work but remains as a text entry. If you type the same text into a cell by using the keyboard, Microsoft Excel interprets the entry as an active hyperlink.
The cause lies here:
Microsoft Excel does not interpret these text values as hyperlinks unless they are typed from the keyboard.
To convert cells that contain valid hyperlink text in Excel to active hyperlinks, use …

I’m sure you are familiar with the traditional way to kill or end a process in Windows using Task Manager.  This method is effective but not nearly as fun as killing a process in Command Prompt.  Additionally, killing processes in Command Prompt provides much more control and the ability to end multiple processes at once.
All of this is possible with the TaskKill command. First, let’s cover the basics.  You can kill a process by the process ID (PID) or by image name (EXE filename).
Open up an Administrative level Command Prompt …

Fixing the Windows 0×80070002 update error by utilizing various methods.

While updating windows, it is possible to receive the 0×80070002 Error. As a result the update process will not be completed, and your computer will not be able to transmit files. The reason for your computer receiving the 0×80070002 Error is due to it not having all of the files that should have been transmitted when updating your software. This is an initialization error that occurs after files have been downloaded, and extracted to the computer.
To fix the error manually, it …

Something goes wrong somewhere, and people get the following problems after the installation of Windows Internet Explorer 8:
- In Windows Explorer (I mean those file explorer for browsing folders/files), when you double-click on a folder, a new Windows Explorer is popped up instead of showing the folder in the same explorer.
- In Windows IE8, when you right-click a web address on a web page, and then click [Open in New Window] or [Open in New Tab], the web page cannot be opened in a new window / tab.
- In Windows …

Some specific viruses can be very difficult to remove by standard means. In addition to that can a virus’ payload damage or undermine system stability, computer security and anti-virus software functionality so that it might be best considering the use of a virus removal tool. Cases when virus removal tools came in handy include dealing with acute virus threats and infections for which vendors of anti-virus software had not yet released a solution, using it  as a patch, or, alternatively, fighting acute worm infections of epidemic scale, especially in a …

Windows Vista is the most secure operating system that Microsoft has produced. With a multitude of features that make the operating system secure; this operating system like ALL operating systems can be made more secure by tweaking the inner workings of Vista. System tweaks for users is often found by the end user. This series explores different methodologies of protecting the operating system while allow the user to keep a work friendly workspace.
Vista Firewall Tweaks
The firewall control in Vista is one of the most important tweaks. Microsoft’s firewall in Windows …

Yoog is a nasty search engine which replaces the default Google search engine in both Firefox and Internet Explorer. This leads to unwanted popups and ads shown. Yoog can be easiliy removed this way:
Firefox

In the URL address box, type about:config and hit enter.
You may get a message like “here be dragons“. If you do, just click the button that is there.
Then you should see a Filter: box. In the Filter box, type keyword As you type this, items will be filtered from the list showing in the window and only …