View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] curiousgeorge408@hotmail.com is offline
external usenet poster
 
Posts: 85
Default How to do bit manipulation in VBA?

I want to pass a floating-point number to a VBA function and access
the binary representation. In C, I might declare a union of double
and 8-element unsigned char array, assign the function parameter to
the double, then access the bits of the unsigned char array.
Alternatively, I might use memcpy() to copy the floating-point
parameter into an 8-element unsigned char array.

How can I accomplish that (either one) in VBA?