first you still have to solve your inital calling problem if you where
going to create an add-in to be loaded into excel. Second, I think you
are wrongg with the speed issue. If you don't declare a variable in VBA
is is assumed to be a variant. When you have variants excels can learn
from the object(s) the properties but this takes longer the first time
you call the code.
Here is an example of the declaration statement when calling a dll from
VBA
Public Declare Function FtpGetFile Lib "wininet.dll" Alias
"FtpGetFileA" _
(ByVal hFtpSession As Long, ByVal lpszRemoteFile As String, _
ByVal lpszNewFile As String, ByVal fFailIfExists As Boolean,
ByVal dwFlagsAndAttributes As Long, _
ByVal dwFlags As Long, ByVal dwContext As Long) As Boolean
The calling process use the Microsoft Standard method for creatting the
call stack. Most compilers on windos have options to either compile the
code as Standard or C-Language. If you don't understand tthe difference
see this article
'Calling convention - Wikipedia, the free encyclopedia'
(
http://en.wikipedia.org/wiki/Calling_convention)
--
joel
------------------------------------------------------------------------
joel's Profile:
http://www.thecodecage.com/forumz/member.php?userid=229
View this thread:
http://www.thecodecage.com/forumz/sh...d.php?t=150545
Microsoft Office Help