Category Archives: Uncategorized

Explorer sort slow after Windows 10 Upgrade

This could be caused by Windows Search from the upgrade –

  1. Open services and turn off Windows Search
  2. Go to C:\ProgramData\Microsoft\Search\Data\Applications\Windows
  3. Delete Windows.edb
  4. Turn Windows Search back on

This will let windows rebuild the search database

 

Advertisements

Duplicating a Partition in Windows 2008 Server

I won’t go into the details, but I used the following tools and info which came in really handy:

http://www.runtime.org/driveimage-xml.htm

http://technet.microsoft.com/en-us/library/cc766465(v=ws.10).aspx

http://www.computerperformance.co.uk/win8/windows8-bcdedit.htm

http://msmvps.com/blogs/richardwu/archive/2010/07/20/changing-the-drive-letter-of-windows-server.aspx

 

gen exists but is not a source folder. Convert to a source folder or rename it

I just had this error while trying out some Java Android sample code in Eclipse.  

I found a good fix on stackoverflow while reading through some comments:

  1. Right click on the project and go to “Properties”
  2. Select “Java Build Path” on the left
  3. Open “Source” tab
  4. Click “Add Folder…”
  5. Check “gen” folder and click Ok and Ok again
  6. Again right click on the project and in the “Andriod Tools” click on “Fix Project Properties”

 

How to export an SSL certificate from Windows 2000

1. Log into Server using Microsoft Terminal Service
2. Click “Start” > “Run” and type “mmc”
3. A new console will open.
4. Goto “Console” > Add Remove Snap-In
5. Click “Add” > “Certificates” > “Add” > “Computer Account” > “Local Computer” > Finish
6. Expand the Console Root > Personal > Certificates
7. You will see your certificate listed there
8. Right Click on your certificate > All Task > Export
9. Export Private Key, you will have to enter a password to password protect the Private Key
10. Specify a path and file name you want to export the certificate to
11. Click Finish to complete

Caspol – Because I don’t trust you

I just had a run in with security on a Windows 2003 server.  I made the simplest little program to run in a cmd window.  It took all of 20 minutes to write and then about 2 hours to find out how to get Windows to trust it enough to run it.  Apparently they took away a tool when they moved to .NET Framework 4 that allowed you to change trust settings.

I don’t know all the details, but this post (and associated utility) really worked out well:

https://brandonpotter.wordpress.com/2010/01/23/code-access-security-policy-caspol-exe-gui-utility/

 

How to make Excel open each file in a separate window

http://my.opera.com/Jarrah/blog/how-to-make-excel-open-each-file-in-a-separate-window

 

An awesome post.

Excel – Saving CSV with Quotes

Whenever I export a file with Excel to CSV, it does not add quotes. Wouldn’t you know it that I’m using an application that requires quotes on input files for CSV. I found the following routine for doing this. You open up the VB editor in Excel, start a new class and add this to it. Then select the TAB you want to export and click RUN. It does the job quite well.

Sub CSVFile()

Dim SrcRg As Range
Dim CurrRow As Range
Dim CurrCell As Range
Dim CurrTextStr As String
Dim ListSep As String
Dim FName As Variant
FName = Application.GetSaveAsFilename(“”, “CSV File (*.csv), *.csv”)

If FName False Then
ListSep = Application.International(xlListSeparator)
If Selection.Cells.Count > 1 Then
Set SrcRg = Selection
Else
Set SrcRg = ActiveSheet.UsedRange
End If
Open FName For Output As #1
For Each CurrRow In SrcRg.Rows
CurrTextStr = “”
For Each CurrCell In CurrRow.Cells
CurrTextStr = CurrTextStr & “””” & CurrCell.Value & “””” & ListSep
Next
While Right(CurrTextStr, 1) = ListSep
CurrTextStr = Left(CurrTextStr, Len(CurrTextStr) – 1)
Wend
Print #1, CurrTextStr
Next
Close #1
End If
End Sub