VBA - Hex To ASCII

[ajocius]

Group,
Is there a function in VBA that will convert hex into ascii.
Example assume I have 0x39 and I want it to convert it to ascii, or 9.
Same goes for the alpha characters as well A thru Z both lower case and
upper case.

Tony

 

[C01d]

Excel provides the Char(value) function, where value is the decima
representation of the ASCII character. The function returns the ASCI
character represented by the number.

Note that before using this function, your code will have to conver
the hexadecimal value to decimal first

 

[AA2e72E]

Try:

Chr(Clng("&H" &yourHEXstring))

 

[Tom Ogilvy]

? chr(&H39)
9