Category: How-to
Excel: Insert multiple rows every other row
The key is to use a macro. To do so, hit Alt+F11, then create a new macro and add the code below. Once added, select the worksheet you’d like to process, change the “17” below (1 if to process all rows), then run it. That’s it. Sub Insert_Blank_Rows() Dim Last As Integer, oRow As…
Configure IIS to allow downloading .dat files
Note: This is for IIS 6.0. Open IIS Manager. Browse to the IIS Site or subfolder where the .DAT files are Right-click on that site or subfolder and select Properties Select the HTTP Headers tab Click on the MIME Types button In the extension box, type ".dat” In the MIME Type box, type "application/octet-stream" Click…
Remotely reboot Linksys WRT54G
I had the need the reboot my Linksys WRT54G router remotely. Unfortunately, the web interface is not like DD-WRT where a reboot button is available; however, there IS a hidden page. 1. Login into the web admin page, which is by default: http://192.168.1.1. 2. Add reset.htm, as in http://192.168.1.1/reset.htm. 3. Click “Yes” to reboot. 4.…
How to add box.net as a local drive
1. Press the Windows key + E or go to the Start menu, right-click on Computer and select Open. 2. Right-click on Computer again and select Add A Network Location, which will prompt the respective wizard. 3. Click Next on the welcoming screen. 4. Then select the second option, Choose a custom network location. And…
PowerShell: Extracting certain lines in any file
I had quite a large file that I needed to parse, and the challenge was to extract certain lines that didn’t match a certain condition. The solution . . . PowerShell, like so: select-string -path filename -notmatch "criteria" | foreach {$_.line} | out-file -filepath filename -encoding ascii That’s it!
Cut-and-paste not working via RDP
Cut-and-paste wasn’t working from me between my RDP session to an XP box from my Windows 7 box. Apparently, the problem was rdpclip.exe wasn’t running. So, if you come across the same issue, check for that process and turn it on if necessary via Run > type rdpclip.