I am currently working with Access 2000 and VBA 6. I have recently got Visual Studio .NET and now I wonder if it is possible to create a dll file in .NET that can be used by VBA 6?
Yes, through COM interop. It's slow, but it'll work.
The best way is to create a new class to act as the COM interface to your .NET code, and then go into the properties for that class and tell it that it needs to be registered for COM Interop. You would then write code in that class to wrapper your .NET functions so that your legacy VBA code will work.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.