Calling VB.NET written functions from outside

[J Staniforth]

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.

[cim3]

Just create your class as a dll and then put a reference to it in your vba code. Simple as that.

[J Staniforth]

Thanks, presumably the client running VBA would need to have the .NET framework installed.

[Edneeis]

Can Office use a standard .NET dll? Or do you have to make it COM like?

[cim3]

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