Accessing manage code from VBA

Anyone know the technique for calling VB.NET methods (C# methods as well) from VBA code?

Although I haven't tried that, but I believe it would be same as calling .NET code from VB6. You will have to build an interoperable DLL and register it in GAC. And then add a reference to it in the VBA code. IF you do a search here, you will number of examples on COM Interop.

Here is a nice example from MSDN :

http://support.microsoft.com/kb/317535