I have a .Net developer creating a DLL that we are going to Reference in an Access VBA application. However, whilst we can see the DLL methods (once referenced), he is struggling with a couple of aspects such as passing variables through and how best the code the .DLL so that Intellisense works as expected.
Whenever I have worked with external references in the past, I usually access them like this (rough example):
Dim obj1 As New TSDialler.Dialer
obj1.SignalKey = "ABC123456"
obj1.TelephoneDestination = "0123456789"
obj1.InternalID = "ZYX987"
If obj1.MakeCall = 1 Then
MsgBox "Call made"
MsgBox "Call not made. Error: " & obj1.ReturnMessage
However, he has never worked in VBA and is struggling with the various aspects. His list of questions is below, but I was wondering if anyone had any links/suggestions for him to look at (more than just answering his questions).
Which kind of methods works?
Do properties work?
Constructors work, what about parameters?
How to do event pattern for a custom class and not UI control?
What pieces (that we use regularly) in C# that does not work with VBA when referenced?
Any article/doc that can be referred that has details for questions like above?
Any help would be greatly appreciated - sorry it's so vague.