Lower(0) = 0
For j = 1 To 4 Step 1
Lower(j) = Lower(j-1) + (26^(j-1))*(10^(4-(j-1)))
Next j
End Sub
Private Function ParseNumber(num As Long) As String
Dim temp As Long,t As Long
Dim ret As String
Dim j As Integer
For j = 4 To 0 Step -1
If num >= Lower(j) Then
temp = num - Lower(j)
Exit For
End If
Next j
Select Case j
Case 4
ret = Chr$(Asc("A") + (((temp \ 26)\26)\26))
ret = ret + Chr$(Asc("A") + (((temp \ 26)\26) mod 26))
ret = ret + Chr$(Asc("A") + ((temp \ 26) mod 26))
ret = ret + Chr$(Asc("A") + (temp mod 26))
Case 3
ret = Chr$(Asc("A") + (((temp \ 10) \ 26)\26))
ret = ret + Chr$(Asc("A") + (((temp \ 10) \ 26) mod 26))
ret = ret + Chr$(Asc("A") + ((temp \ 10) mod 26))
ret = ret + Str(temp mod 10)
Case 2
ret = Chr$(Asc("A") + ((temp \ 100) \ 26))
ret = ret + Chr$(Asc("A") + ((temp \ 100) mod 26))
ret = ret + Str(temp mod 100)
Case 1
ret = Chr$(Asc("A") + ((temp \ 1000) mod 26))
ret = ret + Str(temp mod 1000)
Case 0
ret = Str(temp)
End Select