Friday, May 14, 2010

How To Call DLL Created in .Net From VBA Application

The Following steps are .....
1)First created one Class Library in .net.Writes all the function and methods which are required.

2)For Register DLL for COM INTROP we have to open Solution Explorer of Current project.

3)Select project node then select properties window.

4)Choose Configaration properties then child node with Build tab.

5)In Build tab there is check box for Register For COM Introp ,Check it.

6)Now Compile the DLL/Class Library it is register for COM Introp.

7)Now we can acess this DLL in VBA by simply add Reference of that DLL .


Hope your DLL or Class Library can build from .net to VBA................
Enjoy Code