Tech.It.2.Me->{By.Anton.Perez}

Adding for my own archival purposes:

• Date – ${=String.format(‘%tF’, new Date() + 1)}
• GUID – Guid_${=(int)(Math.random()*100000000)}

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
   

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

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!

I purchased my iPhone 4 around July of 2010, so it’s almost 2 years old. It’s been rock-solid until about a month ago when the “Home” button was working intermittently (i.e. pressing it didn’t activate the phone); tried hard-resetting many times, doing restores, etc., without success.

What fixed it was merely:
1. Get a dust blower or use your and lung power
2. Blow into the power slot (in the bottom) and into the “Home” button. (Note: Press the “Home” button and blow into it from different angles.)
3. Repeat #2 a number of times.
4. Voila! That’s it!

If it worked, the button should have that “clicking” feel once again (I didn’t notice/realize this until after I started having the problem).

Bottom line: Dust in your phone (or everywhere else), especially, in the controls is not your friend.

UPDATE (3/21/12): It started acting up again, despite the fix mentioned above. This is what I found this time, so keeping my fingers crossed (it’ll cost around $150 to get the button replaced at the Apple Store):

Worked for me….

1. Open any application, e.g. Messages.

2. Press and hold the power button until the slide to shutdown bar appears.

3. Release power button.

4. Press and hold Home button with normal pressure and wait until screen returns to icon screen.

5. Enjoy your functioning Home button!

From what I’ve read, this procedure recalibrates the Home button after normal wear or heavy use.