For a technical application I'm using Excel 2013 as a user interface, to show inputs and results with tables and charts.
In this VBA project, calculations are made in a large module that contains only subroutines for number-crunching.
In these subroutines the inputs and outputs are Public variables and there is no reference to Excel objects.
I would like to turn this VBA module in a compiled Add-In, running under the Main program written again in VBA.
Question: what is the easiest way to create this compiled add-in and how to do it?
I don't know C++, but I read somewhere that you can create compiled add-ins for Excel also using VBA.
I would be grateful if you could advise me some papers which explain the best procedure in VB or VBA, in a simple and comprehensive way,with examples step by step.
Any suggestion will be welcome.
Thanks and regards.