Switching Netflix account on Wii

25 03 2012

Here are the steps that you need to do to switch the account.

1. From the Wii home screen click on round “Wii” (Options) button in bottom left corner
2. Click “Data Management”
3. Click “Save Data”
4. Click “Wii”
5. Find “Netflix Channel” (red square with letter N), click on it, select “Erase” and then confirm “Yes”
6. Try to find more “Netflix Channel” icons in that area, scroll to next screen if required (there could be more than one saved block)
7. Return to Wii menu and start Netflix Channel. You should get “Are you a Netflix member?” question and when you answer “Yes” it will show you activation code, which you can use at netflix.com/activate.



Excel: Insert multiple rows every other row

12 03 2012

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 Integer
    ‘Count and select rows to process
    Last = Range("A" & Rows.Count).End(xlUp).row
   
    ’17 is the last row to process (at the top)
    For oRow = Last To 17 Step -1
     If Not Cells(oRow, 1).Value = "" Then
        ‘Copy the line below to as many row insert you need
        ‘in this case, it was 3 row inserts
        Cells(oRow, 1).EntireRow.Insert
        Cells(oRow, 1).EntireRow.Insert
        Cells(oRow, 1).EntireRow.Insert
       End If
    Next oRow

End Sub
   



Configure IIS to allow downloading .dat files

8 03 2012

Note: This is for IIS 6.0.

  1. Open IIS Manager.
  2. Browse to the IIS Site or subfolder where the .DAT files are
  3. Right-click on that site or subfolder and select Properties
  4. Select the HTTP Headers tab
  5. Click on the MIME Types button
  6. In the extension box, type ".dat
  7. In the MIME Type box, type "application/octet-stream"
  8. Click OK


Remotely reboot Linksys WRT54G

2 03 2012

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. Voila!

Another method is to back up your config, the restore it — but do this with caution!



How to add box.net as a local drive

27 02 2012

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 type the following: https://www.box.net/dav

5. If everything goes well, you’ll get a popup window asking you for your credentials. Type your username, which is the email you use to log in to Box.net, as well as your password.

6. Now you can type a name for you to easily identify this location, before clicking Next.

7. You can choose whether to or not to check the box to launch the network location on Windows Explorer after exiting the wizard.

8. Click on Finish.