Hi;
I've prepared a COM AddIn in VB5 to be used in Office2000.
I've managed to add the DLL file to XL2000 and the add-in has a public function which converts a number to string .
Something like;
Public Function yaz(ByRef sayi as double) as string
....
...
End Function
which is placed in a Class Module named "Connect" so that, the COM AddIn installed to XL2000 is "ParaAddIn.Connect"
In VBE, when I give a reference to this DLL (ParaAddIn), I can use the function very well but, when I try to use the same function as standard function in a cell such as
= yaz(A1)
XL2000 does not recognize the function but, the COM AddIn is allready installed.
Can you give me an advice ?
I've prepared a COM AddIn in VB5 to be used in Office2000.
I've managed to add the DLL file to XL2000 and the add-in has a public function which converts a number to string .
Something like;
Public Function yaz(ByRef sayi as double) as string
....
...
End Function
which is placed in a Class Module named "Connect" so that, the COM AddIn installed to XL2000 is "ParaAddIn.Connect"
In VBE, when I give a reference to this DLL (ParaAddIn), I can use the function very well but, when I try to use the same function as standard function in a cell such as
= yaz(A1)
XL2000 does not recognize the function but, the COM AddIn is allready installed.
Can you give me an advice ?