Ago
04-04-2010, 09:11 AM
I dont know how to make a better title.
What i need is a way to set a max value on each item.
What im trying to do is create a function to convert numbers to text as:
001 = AAA
002 = AAB
003 = AAC
026 = ABA (<- not sure about that, but you get the picture).
'width is the number of letters.
'Files is a array of userselected files
'statnumber is what the user defines as startnumber (or letter)
Width = Fix((UBound(Files) + StartNumber) / 25) + 1
ReDim Letters(Width) As Variant
That should give me a array with the correct "width".
What i need now is to make Letters[1,1,1,25] "+1" to make Letters[1,1,2,1] is that possible?
My plan is to use ChrW(Letters(1)+65) & ChrW(Letters(2)+65) ... and so on to make the letter combination.
Or have i missed a simplers solution?
What i need is a way to set a max value on each item.
What im trying to do is create a function to convert numbers to text as:
001 = AAA
002 = AAB
003 = AAC
026 = ABA (<- not sure about that, but you get the picture).
'width is the number of letters.
'Files is a array of userselected files
'statnumber is what the user defines as startnumber (or letter)
Width = Fix((UBound(Files) + StartNumber) / 25) + 1
ReDim Letters(Width) As Variant
That should give me a array with the correct "width".
What i need now is to make Letters[1,1,1,25] "+1" to make Letters[1,1,2,1] is that possible?
My plan is to use ChrW(Letters(1)+65) & ChrW(Letters(2)+65) ... and so on to make the letter combination.
Or have i missed a simplers solution?