I have my dll i.e. class library file made in .net. and a vba application. The code written in vba app need a function written in that particular dll. How can I refer that dll.
In .net its easy, because it follows xcopy deployment. But as i am new to vba, I don't know how to do it. Since my vba file will be distributed to the various clients, I can't afford to make that reference explicitly. i.e. going to tool and then checking component. It should be performed programmatically.
Do I need to install my .net dll on client's machine?? I am asking this because,
since I am not able find my dll with just copy and paste.. what I did is, I wrote CreateObject() method. But eventually I found this message on msdn link... "CreateObject():Creates and returns a reference to a COM object. CreateObject cannot be used to create instances of classes in Visual Basic unless those classes are explicitly exposed as COM components."
Anybody can give any hint or help please...
Can I do it by using shell command?? Does it help me to to register my dll on client's machine (programmatically)??