A problem of invoking C# DLL from VBA

[Paul]

I have a problem of invoking my C# DLL from my VBA code.

I have created the C# component, my code is looking like this:

public class Class1 {
public Class1() {
}
public int TestMethod(int i, int j) {
return i + j;
}
}

and I compiled using Visual studio for C# 2005 (.NET 2.0) with the
"Register for COM interop" option and have the ComVisible(true)
assembly attribute set.

Then I have set the reference to "testdll.tlb" in my Excel VBA
environment.
And my VBA code here

Sub test()
Dim a As testdll.Class1
Set a = New testdll.Class1
End Sub

The problem is.. everytime when I run the macro it complains at the 2nd
line of my VBA code:

"File or assembly name testdll, or one of its dependencies, was not
found."

I spent a day but still unable to figure out which step I was
missing....

If anyone know the answer, please help~~~~

Thank you very much.

Paul

[Shailen Sukul]

The error message seems pretty self explanatory. It seems that your .Net dll
needs a reference to another dll and that has not been deployed with your
main .Net dll. Have a look at the .Net project under references and find out
any third party dlls that are there. You will have to deploy these extra dlls
with your .Net dll for it to work.

Good luck!

"Paul" wrote:

I have a problem of invoking my C# DLL from my VBA code.

I have created the C# component, my code is looking like this:

public class Class1 {
public Class1() {
}
public int TestMethod(int i, int j) {
return i + j;
}
}

and I compiled using Visual studio for C# 2005 (.NET 2.0) with the
"Register for COM interop" option and have the ComVisible(true)
assembly attribute set.

Then I have set the reference to "testdll.tlb" in my Excel VBA
environment.
And my VBA code here

Sub test()
Dim a As testdll.Class1
Set a = New testdll.Class1
End Sub

The problem is.. everytime when I run the macro it complains at the 2nd
line of my VBA code:

"File or assembly name testdll, or one of its dependencies, was not
found."

I spent a day but still unable to figure out which step I was
missing....

If anyone know the answer, please help~~~~

Thank you very much.

Paul

[Paul]

Thanks for the answer..

But first of all, is .NET dll can be used as a "Reference" in ordinary Excel
VBA environment?? Just the machine deployed with .NET framework is okay right?
Thanks.


"Shailen Sukul" wrote:

The error message seems pretty self explanatory. It seems that your .Net dll
needs a reference to another dll and that has not been deployed with your
main .Net dll. Have a look at the .Net project under references and find out
any third party dlls that are there. You will have to deploy these extra dlls
with your .Net dll for it to work.

Good luck!

"Paul" wrote:

I have a problem of invoking my C# DLL from my VBA code.

I have created the C# component, my code is looking like this:

public class Class1 {
public Class1() {
}
public int TestMethod(int i, int j) {
return i + j;
}
}

and I compiled using Visual studio for C# 2005 (.NET 2.0) with the
"Register for COM interop" option and have the ComVisible(true)
assembly attribute set.

Then I have set the reference to "testdll.tlb" in my Excel VBA
environment.
And my VBA code here

Sub test()
Dim a As testdll.Class1
Set a = New testdll.Class1
End Sub

The problem is.. everytime when I run the macro it complains at the 2nd
line of my VBA code:

"File or assembly name testdll, or one of its dependencies, was not
found."

I spent a day but still unable to figure out which step I was
missing....

If anyone know the answer, please help~~~~

Thank you very much.

Paul

[Shailen Sukul]

Sorry I did not read your whole post. It seems that you are not using any 3rd
party dlls. So the next question would be, did you register the .Net dll
using Regasm?

And yes, you will need the .Net framework on the machine with the Excel VBA
Env.

Good luck!

"Paul" wrote:

Thanks for the answer..

But first of all, is .NET dll can be used as a "Reference" in ordinary Excel
VBA environment?? Just the machine deployed with .NET framework is okay right?
Thanks.


"Shailen Sukul" wrote:

The error message seems pretty self explanatory. It seems that your .Net dll
needs a reference to another dll and that has not been deployed with your
main .Net dll. Have a look at the .Net project under references and find out
any third party dlls that are there. You will have to deploy these extra dlls
with your .Net dll for it to work.

Good luck!

"Paul" wrote:

I have a problem of invoking my C# DLL from my VBA code.
>
I have created the C# component, my code is looking like this:
>
public class Class1 {
public Class1() {
}
public int TestMethod(int i, int j) {
return i + j;
}
}
>
and I compiled using Visual studio for C# 2005 (.NET 2.0) with the
"Register for COM interop" option and have the ComVisible(true)
assembly attribute set.
>
Then I have set the reference to "testdll.tlb" in my Excel VBA
environment.
And my VBA code here
>
Sub test()
Dim a As testdll.Class1
Set a = New testdll.Class1
End Sub
>
The problem is.. everytime when I run the macro it complains at the 2nd
line of my VBA code:
>
"File or assembly name testdll, or one of its dependencies, was not
found."
>
I spent a day but still unable to figure out which step I was
missing....
>
If anyone know the answer, please help~~~~
>
Thank you very much.
>
Paul