The original Excel file is modified. The VBA source code is removed (or the project is locked and emptied), and the workbook is linked to the newly created DLL. Specific function calls within the Excel file are routed to the DLL.
It generates object code based on the initial analysis. DoneEx VbaCompiler for Excel
Even great software has hiccups. Here is a cheat sheet for common DoneEx errors. The original Excel file is modified