In order to use some functionnalities of DeMaSy in VBA module, you can use the DLL DeMaSyNET_COMObject. This dll needs to be placed in the same folder as the other DeMaSy dll ( C:\Program Files (x86)\Silicon DNA\DeMaSy ).
This DLL is COM Compatible.You can register it on your computer with the following command line (Run the line as administrator)
C:\Windows\Microsoft.NET\Framework\v4.0.30319\regasm.exe “C:\Program Files (x86)\Silicon DNA\DeMaSy\DeMaSyNET_COMObject.dll” /tlb “C:\Program Files (x86)\Silicon DNA\DeMaSy\DeMaSyNET_COMObject.tlb” /codebase
VB.NET Sample for using COM DLL:
Dim mCOMObject As New DeMaSyNET_COMObject.clsDeMaSyCOMObject
'Open the connection
mCOMObject.Open("C:\Program Files (x86)\Silicon DNA\DeMaSyD.INI", 4, "DOS")
'Launch the process
mCOMObject.CalcBalance("31/12/2018", 1)
'Close the connection
mCOMObject.Close()