onlydarksets

Just another WordPress.com weblog

Archive for the ‘Microsoft Office’ Category

Mounting multiple ISOs

Posted by onlydarksets on November 17, 2008

When installing Office, etc. from our Microsoft Partner MSDN library, I usually take the lazy route and use 7-zip to unpack the ISOs.  ISODisk lets you mount up to 20 ISOs simultaneously, and it seems like a more efficient path.

Posted in Microsoft, Microsoft Office, MS Sharepoint, MS SQL Server, Windows 7, Windows Vista, Windows XP | Leave a Comment »

Soundex for Microsoft Access

Posted by onlydarksets on April 21, 2008

I found this code to add Soundex to Microsoft Access, which is invaluable for deduping records.  However, it has a key error that causes it to fail – the variable name in the private function is incorrect.

It’s a simple fix (see red below).

Function Soundex(strName As String) As String
‘———————————————————–
‘ Input: A string
‘ Outputs: U.S. National archive “Soundex” number
‘   This number is useful to find similar last names
‘ Created By: JLV 03/01/2003
‘ Last Revised: JLV 06/27/2005
‘———————————————————–
‘ A Soundex code is the first letter, followed by
‘ three numbers derived from evaluating the remaining
‘ letters.  Vowels (including Y) and the letters H and W
‘ are ignored.  When consecutive letters return the
‘ same numeric code, the number appears only once.
‘ When two letters with the same code are separated only
‘ by H or W, the second letter is ignored.
‘ Letters are translated to numbers as follows:
‘   B, P, F, V = 1
‘   C, S, G, J, K, Q, X, Z = 2
‘   D, T = 3
‘   L = 4
‘   M, N = 5
‘   R = 6
‘ If the final code after examining all letters is less
‘ than three digits, the code is padded with zeros.
‘ Working variables:
‘ String to build the code, string to hold code number
Dim strCode As String, strCodeN As String
‘ Length of original string, last code returned, looping integer
Dim intLength As Integer, strLastCode As String, intI As Integer
‘ Save the first letter
strCode = UCase(Left(strName, 1))
‘ Save its code number to check for duplicates
strLastCode = GetSoundexCode(strCode)
‘ Calculate length to examine
intLength = Len(strName)
‘ Create the code starting at the second letter.
For intI = 2 To intLength
   strCodeN = GetSoundexCode(Mid(strName, intI, 1))
   ‘ If two letters that are the same are next to each other
   ‘ only count one of them
   If strCodeN > “0” And strLastCode <> strCodeN Then
     ‘ Different code number, add to the result
     strCode = strCode & strCodeN
   End If
   ‘ If this is not the special “skip” code (H or W)
   If strCodeN <> “0” Then
     ‘ Save the last code number
     strLastCode = strCodeN
   End If
‘ Loop
Next intI
‘ Check the length
If Len(strCode) < 4 Then
   ‘ Pad zeros
   strCode = strCode & String(4 – Len(strCode), “0”)
Else
   ‘ Make sure not more than 4
   strCode = Left(strCode, 4)
End If
‘ Return the result
Soundex = strCode
End Function

Private Function GetSoundexCode(strCharString) As String
‘———————————————————–
‘ Input: One character
‘ Output: U.S. National archive “Soundex” number
‘   for the specified letter
‘ Created By: JLV 03/01/2003
‘ Last Revised: ZHM 04/21/2008
‘   – Fixed error in variable names
‘———————————————————–
Select Case strCharString
   Case “B”, “F”, “P”, “V”
    GetSoundexCode = “1”
   Case “C”, “G”, “J”, “K”, “Q”, “S”, “X”, “Z”
     GetSoundexCode = “2”
   Case “D”, “T”
     GetSoundexCode = “3”
   Case “L”
     GetSoundexCode = “4”
   Case “M”, “N”
     GetSoundexCode = “5”
   Case “R”
     GetSoundexCode = “6”
   Case “H”, “W”
     ‘ Special “skip” code
     GetSoundexCode = “0”
End Select
End Function

Posted in Microsoft Office | 2 Comments »

ScanPST.exe location

Posted by onlydarksets on March 20, 2008

I just upgraded to Vista Enterprise SP1, and I found that my backup PST was corrupted.  Outlook told me to run ScanPST.exe, but didn’t bother telling me where it was.  According to the KB article, it’s located in the Common Files directory.  However, with Microsoft Office 2007 Enterprise, I found it here:

C:\Program Files\Microsoft Office\Office12

Obviously this isn’t an insurmountable obstacle, but hopefully this will help.

UPDATE: One commentor found it in yet another location. C:\Program Files\Common Files\System\MSMAPI\1033

UPDATE #2: For x64, substitute “Program Files (x86)” for “Program Files” in the above paths.  Thanks, Travis!

Posted in Microsoft Office, Windows Vista | 20 Comments »