Writing hex numbers to a binary file

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fan924 - 26 Sep 2007 02:55 GMT

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?

Reply to this Message

JW - 26 Sep 2007 04:37 GMT

> 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),
[quoted text clipped - 3 lines]
> 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

Reply to this Message

Fan924 - 26 Sep 2007 04:56 GMT

My fault again, I forgot to specify Excel 97.

Reply to this Message

sali - 26 Sep 2007 07:39 GMT

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

"Fan924" <a924fan@yahoo.com> je napisao u poruci interesnoj
grupi:1190778998.322390.69220@k79g2000hse.googlegroups.com...

> My fault again, I forgot to specify Excel 97.

Reply to this Message

Fan924 - 26 Sep 2007 19:48 GMT

It didn't work.

Reply to this Message

sali - 27 Sep 2007 11:08 GMT

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?

"Fan924" <a924fan@yahoo.com> je napisao u poruci interesnoj
grupi:1190832484.247166.146440@50g2000hsm.googlegroups.com...

> It didn't work.

Reply to this Message