Visual Basic 2008 dll & Excel VBA code

[bjdesa]

Yes I have been trying to call the function MULT in the Dll file
called ClassLibrary1.dll

I compiled the Visual Basic 2008 DLL for example

Public Class Class1
Public Shared Function MULT (ByVal ARG1 As Double, ByVal ARG2 As
Double) As Double
MULT = ARG1 * ARG2
End Function
End Class

Then from VBA in Excel

Public Declare Function MULT Lib "E:\Visual Studio 2008\Projects
\ClassLibrary1\ClassLibrary1\bin\Release\ClassLibrary1.dll" (A1 As
Double, A2 As Double) As Double

When I try and test it using

Sub test()
Dim A1 As Double
A1 = MULT (4.5, 3.6)
End Sub

It errors off with Run-time error 453 Can’t find DLL entry point MULT

I am sure there must be an error on Visual Basic 2008 side. So what am
I missing?

[Michael Cole]

bjdesa expressed precisely :

[SNIP]

> I am sure there must be an error on Visual Basic 2008 side. So what am
> I missing?

Wrong newsgroup - this is for VB6 and earlier. You should ask any
questions about VB.Net in a dotNet group.

--
Michael Cole