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

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

--
C01
-----------------------------------------------------------------------
C01d's Profile: http://www.excelforum.com/member.php...fo&userid=3442
View this thread: http://www.excelforum.com/showthread.php?threadid=54414

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