Is it possible - and if so how? - once you've created loads of functionality in VB.NET to be able to utiliise this from outside of .NET - primarily with MS Office (2000) code.
Printable View
Is it possible - and if so how? - once you've created loads of functionality in VB.NET to be able to utiliise this from outside of .NET - primarily with MS Office (2000) code.
Just create your class as a dll and then put a reference to it in your vba code. Simple as that.
Thanks, presumably the client running VBA would need to have the .NET framework installed.
Can Office use a standard .NET dll? Or do you have to make it COM like?
You have to make it COM like. Check out these 2 articles which shed some light on the situation.
http://www.c-sharpcorner.com/vbnet/COMinCSharpM.asp
http://dotnet247.com/247reference/msgs/25/128704.aspx