VBA - Hex To ASCII

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

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

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

Try:

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

? chr(&H39)
9

--
Regards,
Tom Ogilvy


"ajocius" wrote:

>
> 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
>
>
> --
> ajocius
> ------------------------------------------------------------------------
> ajocius's Profile: http://www.excelforum.com/member.php...o&userid=17695
> View this thread: http://www.excelforum.com/showthread...hreadid=544141
>
>