Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Value manipulation | Excel Discussion (Misc queries) | |||
Graph Manipulation | Excel Discussion (Misc queries) | |||
For better Performance in VBA for Excel - Strings manipulation OR Objects manipulation | Excel Programming | |||
String manipulation | Excel Programming | |||
Bit manipulation | Excel Programming |