On Sep 25, 9:55 pm, Fan924 wrote:
I finally figured this out with help from some of you. Open a file,
convert hex to decimal numbers, convert to a character (Chr Function),
and write to file. It works great. Problem..... I can't figure how to
do a HEX2DEC conversion within the macro. Just to test all this, I
created a column next to the hex data using the HEX2DEC function. I
would like to do this without creating a column of decimal numbers.
Any ideas from the expert?

Have a look here.
http://www.vbaexpress.com/kb/getarticle.php?kb_id=307