How to create a VBAProject References dll using C# or other language

Question

0.00/5 (No votes)

See more:

I want to create BLL(Business Logic Layer) & DAL(Data Access Layer) in VS2008 using C#, compile it to dll. Then I can use the classes in the dll by add it to the VBAProject.

Can someone help me? tell me how to do or give me some reference, thanks!

Posted 13-Aug-12 4:53am

virusx1984

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wes Aday · Accepted Answer · 2012-08-13T04:58:00

Solution 1

This[^] article shows you how to do this very thing.

Posted 13-Aug-12 4:58am

Wes Aday

Comments

Abdul Quader Mamun 13-Aug-12 11:32am

easy Answer!

[no name] 13-Aug-12 17:23pm

I will take easy! :-) Thanks.

Sergey Alexandrovich Kryukov 13-Aug-12 17:19pm

5ed.
--SA

[no name] 13-Aug-12 17:23pm

Thanks Sergey

virusx1984 13-Aug-12 19:18pm

I create the dll as the article, and it run the correct result. But I can't see the Members of class in Object Browser of VBE of Excel. I just can see the SimpleCalc Library and the Calc class. The SetNumberOne method , SetNumberTwo method and the Add method are both not show, any solution?

[no name] 14-Aug-12 9:22am

It would be impossible for me to say. The times that things have not worked out for me when following a tutorial is usually missing a step. Make sure that you followed the steps correctly. Did you copy the files to the correct location? Are the methods and properties public? Are the COM checkboxes in the project properties correctly set?

virusx1984 14-Aug-12 11:36am

It worked fine, and I got the right result as the tutorial said. I just found that the object of the Calc couldn't auto list its public member (such as "Add()" , "SetNumberOne(int)") when I press the "." button behind the object name.