strange "overload" error at only 32999

[BlackMustard]

hi all,

i am trying to convert the string "32999" to a number, in order to compare it to other numbers and tell which one is the largest one, or if they're equal.

i keep getting an overflow error. this is for a macro organizing numbered folders, so i started out with lower numbers using

CInt(myNumberString)

which worked fine up to this point.
the odd thing is that i get overload using CLng and CDbl as well, even though i understand the limits for long and double numbers should be much higher. i have debugged and verified that the string being converted is really "32999".

what should i do to solve this?

(i'm writing vba for outlook 2003, running on win2k)

[BlackMustard]

i found the problem myself:

32999 is a number too large to store in an integer variable - but even though i changed the explicit conversion to double, the variable was still declared as an integer. therefore, an implicit conversion to integer took place, which caused the overflow.

[jamesd0142]

Try using long im not sure what the max value of this is but its certainly bigger than standard integer.