I am trying to use Excel to connect to Baan ERP system. I am getting an error with this piece of code and I can't find any help on it. I can connect with Baan but when I call the object I am having a problem and the function call is not working correctly. Can anyone help me?
'***************************************************************************************
' Name : SendtoBaan
' Short Description : Send/Receive information to/from Baan
' Comments : Check if Baan is active otherwise connect to Baan
' send information to Baan with parseexecfunction with 2 parameters
' a) dllname
' b) dllfunction (includes parameters)
' return information checked for errors and messages displayed
' Also if a record has an error the error flag switch is turned on
'***************************************************************************************
Sub SendtoBAAN(ByVal dllname As String, ByVal dllfunction As String)
If BaanObj Is Nothing Then
ConnectBaan
End If
BaanObj.ParseExecFunction dllname, dllfunction
This last line is where it stops in the debugger. It is part of an add-in that came with Baan.
'***************************************************************************************
' Name : SendtoBaan
' Short Description : Send/Receive information to/from Baan
' Comments : Check if Baan is active otherwise connect to Baan
' send information to Baan with parseexecfunction with 2 parameters
' a) dllname
' b) dllfunction (includes parameters)
' return information checked for errors and messages displayed
' Also if a record has an error the error flag switch is turned on
'***************************************************************************************
Sub SendtoBAAN(ByVal dllname As String, ByVal dllfunction As String)
If BaanObj Is Nothing Then
ConnectBaan
End If
BaanObj.ParseExecFunction dllname, dllfunction
This last line is where it stops in the debugger. It is part of an add-in that came with Baan.
