I have been trying to write an RTD com server in C++ to display the user defined data. My question here is: Could we send a user defined data type, i.e. Employee, from the RTD server in the callback and unpack in the VBA code?
VBA code: //get employee here, unpack and put in the excel
Private Sub Worksheet_Calculate()
Dim changedRange As Range
On Error Resume Next
Set changedRange = Range("Lookup!tbData")
On Error GoTo 0
If Not changedRange Is Nothing And changedRange.Count = 1 Then