Your code only works because of the StrPtr function which is no
documented in VBA. And it is weird that you have to specify that Strpt
yo need to pass using Byval instead of the default ByRef. I wouldn'
use Any as the variable type of the pointers instead I would use LON
since a pointer is really a long in VBA.
The Strptr() function basically skips the header that VBA put infron
of a variable which contains the Variable type and number of characters
If yo uwere using VB6 yo can specify the compiling option and us
C-Language variable passing instead of the Microsoft Standard variabl
passing.
Again it is easier and clearer to write this code in C-language than i
VBA
--
joe
-----------------------------------------------------------------------
joel's Profile: 22
View this thread:
http://www.thecodecage.com/forumz/sh...ad.php?t=16635
[url="http://www.thecodecage.com"]Microsoft Office Help[/url