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?

How to do bit manipulation in VBA?
 

Hi George:

http://groups.google.com/group/micro...u p%3A*excel#
--
Gary''s Student - gsnu2007a


" wrote:

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?

How to do bit manipulation in VBA?
 

On Nov 24, 12:09 pm, Gary''s Student
wrote:
http://groups.google.com/group/micro...rogramming/bro...

Thanks for the pointer. (Sigh, Google Groups seems to be truncating
the URL in this response.)

I did see this thread when I searched GG before posting my inquiry.
But I was unable to look at threads from early 2005 and earlier,
including this one. I ass-u-me-d that GG kept the NG index, but not
the articles. (I thought that was odd, but I imagined a dubious
benefit.) But after I clicked on your link, I discovered that all the
links in the search result now work. I'm sure it has nothing to do
with clicking on your link. The earlier failure must've been a hiccup
in the GG intranet. Klunk! I'll try to be more patient in the
future.

Anyway, this is a great(!) pointer. It sparks some follow-up
questions, which are non-technical. I hope someone will be kind
enough to offer some insight.

First, where can I learn (more) about the user-callable entry points
in the Kernel32 lib -- and any other system libs that might be
accessible to VBA programs?

I don't 'spose there are "man pages" <wink.

(My VBA book does mention some useful entry points and how to use
them. But it is not complete, by a long shot.)

Second, where can I learn (more) about the VBA language?

I'm looking for the "K&R" of VBA <wink.

My VBA book, which is one of the most recommended in these NGs, does
not mention LSET, for example. At least, not that I recall. The
book's index is terrible. So it is possible that LSET is mentioned in
context somewhere, and I simply can no longer find it (like almost
everything else), having no idea in what context the author chooses to
introduce what <sigh.

How to do bit manipulation in VBA?
 

Hi George:

For API info you might checkout Ivan Moala's site:

http://www.xcelfiles.com/Index.html

or

http://www.answers.com/library/Win+APIs

or

http://www.andreavb.com/API_USER32.html

Have fun with this !

--
Gary''s Student - gsnu2007b


" wrote:

On Nov 24, 12:09 pm, Gary''s Student
wrote:
http://groups.google.com/group/micro...rogramming/bro...

Thanks for the pointer. (Sigh, Google Groups seems to be truncating
the URL in this response.)

I did see this thread when I searched GG before posting my inquiry.
But I was unable to look at threads from early 2005 and earlier,
including this one. I ass-u-me-d that GG kept the NG index, but not
the articles. (I thought that was odd, but I imagined a dubious
benefit.) But after I clicked on your link, I discovered that all the
links in the search result now work. I'm sure it has nothing to do
with clicking on your link. The earlier failure must've been a hiccup
in the GG intranet. Klunk! I'll try to be more patient in the
future.

Anyway, this is a great(!) pointer. It sparks some follow-up
questions, which are non-technical. I hope someone will be kind
enough to offer some insight.

First, where can I learn (more) about the user-callable entry points
in the Kernel32 lib -- and any other system libs that might be
accessible to VBA programs?

I don't 'spose there are "man pages" <wink.

(My VBA book does mention some useful entry points and how to use
them. But it is not complete, by a long shot.)

Second, where can I learn (more) about the VBA language?

I'm looking for the "K&R" of VBA <wink.

My VBA book, which is one of the most recommended in these NGs, does
not mention LSET, for example. At least, not that I recall. The
book's index is terrible. So it is possible that LSET is mentioned in
context somewhere, and I simply can no longer find it (like almost
everything else), having no idea in what context the author chooses to
introduce what <sigh.

How to do bit manipulation in VBA?
 

On Nov 25, 5:21 am, Gary''s Student
wrote:
http://www.answers.com/library/Win+APIs

Thanks for the pointers.