Calling a DLL

[Augusto Afonso]

Hi All,

I'm trying to call a dll from within Excel 2000. This is what I´m doing:in
cell B1 I include this code: =CALL("MyDll";"Mult";"JJJ!";C1;D1)
in C1 and C2 there are any integers.

what I get is the FALSE word in cell B1.

Inside the DLL there is only one function (Mult) that multiplies two
integers and returns another integer. It works ok out of excel.Any comments
are welcome.Augusto.

 

[Jerry W. Lewis]

http://support.microsoft.com/default.aspx?scid=kb;en-us;213554

may have some useful information. Your DLL must use _stdcall calling
convention, or you cannot use it. I have not experience with the CALL()
function, but using a VBA declaration and passing arguments ByVal has
worked well for me.

Jerry