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

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

Found this on stackoverflow after I had issues with an SSL (self-signed) certificate on a client machine – it still didn’t work even after installing the cert via the browser.  The fix, in addition to installing the actual certificate, was to add the Certificate Authority on the client machine.

On the web server:

• Win+R, MMC, Enter.
• File, Add-Remove snap-in, Certificates, Add, Manage certificates for: my user account, Finish, OK.
• Navigate to "Certificates – current user / Trusted Root Certification Authorities / Certificates".
• Find your certificate, right-click, All tasks / Export.
• "No, don’t export the private key"
• "DER Encoded binary X.509 (.CER)"
• Save the file somewhere.
• Transfer the newly created .CER file to the client PC.

On the client machine:

• Win+R, MMC, Enter.
• File, Add-Remove snap-in, Certificates, Add, Manage certificates for: my user account, Finish, OK.
• Navigate to "Certificates – current user / Trusted Root Certification Authorities / Certificates".
• Right-click on Certificates container, All tasks / Import
• Choose your .CER file you’ve transferred from the server machine.
• On the next screen, choose "Place all certificates in the following store", click "Browse", check "Show physical stores", then choose "Trusted Root Certification Authorities / Local Computer".
• Press "Finish" finally.
• In Internet Explorer: Tools – Delete browsing History,
• In Internet Explorer: Tools – Internet options – "Content" tab – Clear SSL state button.

In case you’re having an issue watching Netflix through Windows Media Center because of an “Authorization failure…” error, try the following (it worked for me):

1. Exit Media Center.
2. Open Internet Explorer and click Tools and then Internet Options.
3. Click the Delete button – check all of the check-boxes and then click the Delete button. Click OK.
4. Browse to http://www.netflix.com and sign in. Note: No need to save the passwords in IE.
5. Close Internet Explorer.
6. Open Netflix and play anything.
7. Click Yes to the pop-up.

That’s it. Hope it works for you like it did on mine.

I came across an “HTTP Error 500.19 – Internal Server Error” error when trying to access a static page on IIS 7 running on Windows 2008 Server.  So, here’s what I did that fixed the issue:

1. Checked the event logs first and saw this:

2. Checked out the ISAPI Filters of the “Default Web Site” as stated in the event log and look what came up:

3. Next, checked “c:\Windows\System32\inetsrv\config\applicationHost.config” and voila, saw two entries for “ASP.Net_2.0_for_V1.1”:

Line 312:

<isapiFilters>
            <filter name="ASP.Net_2.0.50727.0" path="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll" enableCache="true" preCondition="bitness32,runtimeVersionv2.0" />
            <filter name="ASP.Net_2.0_for_V1.1" path="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll" enableCache="true" preCondition="runtimeVersionv1.1" />
            <filter name="ASP.Net_4.0_64bit" path="c:\Windows\Microsoft.NET\Framework64\v4.0.30319\aspnet_filter.dll" enableCache="true" preCondition="runtimeVersionv4.0,bitness64" />
            <filter name="ASP.Net_4.0_32bit" path="c:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_filter.dll" enableCache="true" preCondition="runtimeVersionv4.0,bitness32" />
        </isapiFilters>

Line 960:

<location path="Default Web Site">
<system.webServer>
<isapiFilters>
<filter name="ASP.Net_2.0_for_V1.1" path="%windir%\Microsoft.NET\Framework\v2.0.50727\aspnet_filter.dll" />
</isapiFilters>
</system.webServer>

After removing the second <filter name…> in line 960 (like so below), and restarting IIS, everything worked as expected. 

<location path="Default Web Site">
<system.webServer>
<isapiFilters>
</isapiFilters>
</system.webServer>

Hope this helps someone out there.