Esteemed Forum Participants and Lurkers:
===============================
Excel 2003 VBA
How do I convert an Array of Bytes into a Single?
I know that the 4-Byte IEE 754 hex code in Single format for -8.125 = C1020000
I Dim a byte array:OK ... the order is probably reversed ... but how do I get this into a type Single variable "aSing" so that I can "MsgBox aSing" and display the correct decimal value? Of course, this is just asking how to implement C's "AddressOf" pointer in VBA.Code:Dim aByte(3) As Byte aByte(3) = &HC1 aByte(2) = &H2 aByte(1) = 0 aByte(0) = 0




Reply With Quote