|
-
Apr 5th, 2010, 04:14 AM
#1
Thread Starter
New Member
VB.Net DLL in VBA
Hi
somebody please help me, how to access the DLL created in VB.Net from VBA. I created the class library in VB.Net2008. It works fine if I call the DLL from another VB.Net program. When I try to use it in VBA, it is not working, when I searched other websites, there are some many confusing explanations about COM, compile, etc.
I have a function
Class1
private function adduk(a as integer, b as integer)
dim c as integer
c=a+b
return c
End Function
End Class1
In VBA I called the dll as
Public Declare Function additionuk Lib "d:\ClassLibrary1.dll" (aa As Integer, bb As Integer) As Integer
and in the main module I called like
c = adduk(a,b)
But it is not working. Somebody please help me how to find a solution.
Thanks
Deuche
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|