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()