(Excel) Encode Integer to Hex or Base64 using N Bytes

Demonstrates how to write an integer to N bytes (little-endian or big-endian) and return the bytes in any encoding such as hex, base64, etc.

Note: This example requires Chilkat v9.5.0.77 or greater.

Download Excel Class Modules Chilkat Excel Class Modules

Dim crypt As Chilkat.Crypt2
Set crypt = Chilkat.NewCrypt2

' 1193046 decimal is equal to 0x123456 hex.

value = 1193046

' Write the integer in 8 bytes using little-endian byte-order and return as hex

bLittleEndian = True

s = crypt.EncodeInt(value,8,bLittleEndian,"hex")
' The output is: 5634120000000000
Debug.Print s

' Now use big-endian...
bLittleEndian = False
s = crypt.EncodeInt(value,8,bLittleEndian,"hex")
' The output is: 0000000000123456
Debug.Print s

' Instead of hex, get the 8 bytes using base64.
s = crypt.EncodeInt(value,8,bLittleEndian,"base64")
' The output is: AAAAAAASNFY=
Debug.Print s