-
Notifications
You must be signed in to change notification settings - Fork 84
Open
Description
I followed the instructions in the sample\DNAComServer.
When starting Excel in debug mode the =DnaComServerHello() works fine in the sheet.
Using the functions in VBA with early or late binding isn't working.
Sub TestLateBound()
Dim dnaComServer As Object
Dim hello As String
Dim result As Double
Set dnaComServer = CreateObject("DnaComServer.ComLibrary")
hello = dnaComServer.ComLibraryHello()
result = dnaComServer.Add(1, 2)
Debug.Print hello, result
End Sub

Runtime error 424 - object required.
Similar with early binding.
Set the reference on the tlb is fine.
But then an error occurs when starting the sub.
Are there any hints what to do to fix that issue?
Metadata
Metadata
Assignees
Labels
No labels