How to listen event in VBA generated from C# dll - Dll is loading at runtime

[maamirk]

Hi ,

I have a c# dll. My client (consumer of dll) is VBA (Ms Access).
I need to load dll runtime (dll is not registered). I cannot register dll in registry, its a requirement. I am loading dll using LoadLibrary API.
I can call C# dll method but now question is how can i catch events generating in dll?

How can i implement event listener in VBA. I was thinking of using WithEvents but it requires type at declaration which i don't have because loading dll runtime. I don't have any reference.

Could you please help with simple example.

Thanks
Muhammad