decoding HexaDecimal

[NigelShaw]

Hi Guys,

im correct in saying that Hexadecimal is in this-

eb 05 6f ff 00 c0 f1

Using Vba, can it be converted to a text, string or ascii?


Cheers

Nigel

 

[John Big Booty]

There is some discussion here on the subject, that may do what you want.

 

[vbaInet]

im correct in saying that Hexadecimal is in this-

eb 05 6f ff 00 c0 f1

Using Vba, can it be converted to a text, string or ascii?

To get the number of the hex eb, you would use Val("&Heb")

So to get the number of the hex of the string above you need to break it down into small bitesize chunks, give it a good swirl (i.e. loop through each part), and feed it to the Val() function above with the &H before the text.

 

[gemma-the-husky]

nigel - the 00 will be an issue though

char 00 is an end of string terminator, i think. character strings with embedded chr(0) will perform strangely.

i was trying to do some encryption, and had this problem.


the other issue may also be that access chars are unicode, therefore there should be 2 bytes per char - which again can trap the unwary!