little endian to big endian double

[prossu]

I have an apparatus driven by Labview that saves double data as binary for speed reasons. The problem is that for historical reasons Labview uses little endian IEEE-64 bit doubles and excel (like most windows programs) wants big endian IEEE-64 bit doubles. I need to be able to reverse the byte order and convert to double. I can read in the data as string *8 and reverse the byte order, but I can't figure out how to get the result converted to double. I have some vague recollection that in earlier versions of basic there was a fcn (MCVRT?)to do this but can't find anything now.

[Pauleyb]

Tricky. Excel does not allow you to 'access' the true bytes. Here is something I found, but I'm not sure it will work in Excel VBA:
http://stackoverflow.com/questions/1...ay-into-double

[Pauleyb]

Wow! It worked! I was dubious that code would work in Excel VBA. Thanks for the rep bump.

Please take the time to mark this as SOLVED (and include your code if you made any modifications - I'm curious).

Pauley