wheframe.blogg.se

So the class library youĬreated in C# or VB.Net must be created as a COM visible assembly.

On the Assembly Information window, check Make assembly COM-Visible.Īpplications created in VB or VBA are COM-based applications. When the project properties window is opened, click Application tab, and then click Assembly Information button. Go to menu Project -> SimpleCalc Properties. Configure project properties to make it COM visible.

The method adds two integer numbers and returns the result.Ģ. This class has two variable members and one Add() method. Save the project (and solution) as SimpleCalc.īelow I created a simple calculation class for testing. Create a new C# (or VB.Net) project and select Class Library as the template type. Hope the tips can save you a couple of hours or days of headaches.ġ. In this article, I'm going to show you how to correctly create a C# or VB.Net DLL in Visual Studio and use it inside MS Access, Excel VBA, or VB6 applications. (1) how to correctly create a DLL for Access or Excel (or any Microsoft Office applications or VB6 applications), (2) how to correctly registerĪ C# or VB.Net DLL, and (3) how to correctly reference the DLL within Access VBA or Excel VBA. After some research on this issue, I learned some new tricks about "Can't add a reference to the specified file.".

The best way nowadays is to use C# or VB.Net to create the DLL.Ĭreating a DLL in C# or VB.Net is not that hard as long as you have object oriented programming experience or knowledge.Īfter creating the DLL, I tried to reference it from Access VBA editor but kept getting the message I used to use VB (Visual Basic 5 and 6) to createĭLLs many years ago. I was updating an application I created in Access VBA and came across a scenario that I needed toĮncapsulate some of the functionalities in a DLL.