Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dll from .NET in VBA 6

Status
Not open for further replies.

Larsson

Programmer
Jan 31, 2002
140
SE
Hi!

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?

If it is possible, then how do I use it in VBA 6?

Larsson
 
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.

Chip H.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top