Writing hex numbers to a binary file

F

Fan924

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?
 
J

JW

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?
Click to expand...

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

sali

just test&use it.
as to my experience, 99.99999% of excel macro is compatible with all
versions, back to the excel-5 from the year 1993
 
S

sali

it couldn't be a version 97-2002 problem, maybe something else

if you are still interested, please clarify the way "it didn't work"
you got the vba compiler error message, or wrong result?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Any way to add hex numbers? 1
Convert text to hex 3
Excel 2007 VBA: Convert laaaaarge number to Hex 27
Convert numbers to HEX 6
Setting a cell's color based upon RGB values 6
Import binary file and convert to HEX data 2
convert hex-values to decimal values 6
Can I use HEX2DEC with cell references vs. numbers? 8

Top