VBA – Add a C# library to a VBA project

For today I was thinking to present an algorithmic problem, but somehow I have decided to show something more useful. It is a Step-by-step instruction for the creation of a C# object in VBA. You know, that references, which you can add through Tools>References from the VB Editor.

Let’s start with it. First, make sure that you run Visual Studio as an administrator like this:

pic00

Then select File>New Project> Class Library. And paste the following code in the new class:

Pretty much, it has 3 fields, 2 of which are private. “Days” is read only, Years – not. We have also 3 other string functions, just to have something. Once we are ready, select “Project” and then ProjectName Properties. In my case it is LibraryVBA Properties, because my project is named LibraryVBA.

pic01

Now the magic starts. Make sure to click on Assembly Information and to give meaningful description, it would be the one showing in the libraries in Tools>References, once we go to the VB Editor. Last but not least here – check on “Make assembly COM-Visible”.

pic02

Then on “Build”. There check “Register for COM interop” and change bin\Debug\ to bin\Release01 (or bin\ReleaseN)

pic03

So far so good. Press F6 and hope for the magic to start. Usually nothing should happen, just a small notice on the lower left corner of your visual studio, saying “Build started” and the “Ready”. And yup, in the specified folder we should have a LibraryVBA.tlb file. (or something similar).

pic04

Now, open the beloved VBEditor and go to Tools>References. Press on Browse and navigate to that *.tlb file. Now “OK”. Now, you may refer the object by its namespace and class. Like me -> LibraryVBA.clsInformation. The VB Editor does not support you with IntelliSense for the new object, but still it is quite ok. This is what you can do with it:

pic05

The VBA code is here:

Pretty much, that’s all! Now you may proudly say all over the world, that you are able to create your own libraries in C# and use them in VBA. Enjoy it! 🙂

About

A VBA Developer.

Tagged with: , ,