Using NPlot .NET component in Access VBA
-
I have need of NPlot within a VBA application I am developing. There are .NET 1.1 and 2.0 dlls available, and also the C# source code. I have been doing some reading on C# interoperability with COM, but I cannot get my head around it, as my C# and .NET skills are severly lacking. Is it possible for someone to guide me on how exactly to enable COM interoperability in NPlot, so I can insert an NPlot control inside a VBA form? I'm required to use the .NET 1.1 version, as it is the only framework installed on all PCs at my workplace. Thank you :)
-
I have need of NPlot within a VBA application I am developing. There are .NET 1.1 and 2.0 dlls available, and also the C# source code. I have been doing some reading on C# interoperability with COM, but I cannot get my head around it, as my C# and .NET skills are severly lacking. Is it possible for someone to guide me on how exactly to enable COM interoperability in NPlot, so I can insert an NPlot control inside a VBA form? I'm required to use the .NET 1.1 version, as it is the only framework installed on all PCs at my workplace. Thank you :)
Hi there, First in the C# source Code (For VS2005), right click in the project select properties and goto Build section on the bottom select "register For COM Interop" (do that for all projects in the solution), now if you Build the Solution in the Debug/Release directory beside the .exe/.dll it will create .tlb files, now you need to register to the GAC, go to Start-->run and write: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\regasm "YourPath"\YourDll.dll /codebase tlb:"YourPath"\YourDll.tlb /verbose now you can use the CreateObject from VBA to intatiate and you the assembly. PS. you have to register ALL dlls. Hope that helped. Nassos
"Success is the ability to go from one failure to another with no loss of enthusiasm." Winston Churchill "Quality means doing it right when no one is looking." Henry Ford