I need a function that can convert big numbers into hex representation and vice versa.
The Hex$ function only works for small numbers. For big numbers like 12345678901234, Hex$ throws an Overflow error.
Here is what I have been trying to do:
Dim sHex As String, C as Currency
C = 12345678901234
sHex = Hex$(C) ' I get an Overflow error on this statement!