Facade Pattern (VBA to .NET)
This is code possible through .NET, in that it bridges across to COM for automation in VBA. This concept can be extended to work for many other COM-based applications. This code allows the add-in to expose internal .NET-coded procedures to Excel COM, extending the use of the .NET code.
Handle interface between different, incompatible systems
The interface is required because COM is interface-based
Other code elements are required for this to work properly
Registering the DLL
Creating the AdapterForVBA class on startup
Click the download button for FacadeForVBA.cs...