Convert a string to a number

[Per9922]

Hello,

I have a string of 8 bytes that I would like to convert to a number. I read the bytes from a file and I need to change the order of the bytes before converting the number to a string according to the following.

96 6A 45 43 39 01 00 00 -> 00 00 01 39 43 45 6A 96

How do I do I change the order and convert the string to a number in VBA ?

Thanks Per

 

[Per9922]

Thanks again!

There are no avaiable function in VBA that do this ?

 

[strongm]

Oh, I think this can be done a little more easily., but I'm not near a machine itch Vba on it currently

 

[PHV]

strongm, you thinked about a CopyMemory API call ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MakeItSo]

OK, found something.
As every so often, Google is your friend - if know exactly what to look for.

Lookey here (scroll to the last post):

http://www.vbforums.com/showthread.php?612198-RESOLVED-Hex-to-Float-Conversion-in-VB6

Does that do what you want it to do? Can't try it myself at the moment.

“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.

 

[strongm]

>CopyMemory

In essence. But I would do it without resorting to the API directly, and use LSet as per the link provided by MakeItSo (and note if he'd searched on THIS site, he'd have found how to do this as well; here's one of my posts on the subject, dated about 6 years ago ... thread222-1183258

 

[strongm]

Doesn't look like Per9922 cares for theselatter methods.