Excel Interop/DCOM to OpenXml/EPPlus

Question

Hi,

In our server side application, clients can upload .xlsm files (after they modified a macro).

Then the server is using these .xslm as a model to create new file, add data in sheets and run the macro.

(server is doing that as jobs at night because macros are big).

Until now, we were using Excel Interop/DCOM to manage the Excel files.

But it is no longer recommended.

Its better to use OpenXml, EPPlus or any other third-party library to modify Excel file.

Unfortunately, only Excel Interop/DCOM can open the files and run the macro.

I would like to know if someone already had this problem and if there is any solution ?

Thanks for your help.

Alain.

P.S. : re-coding macros using OpenXml seems difficult as each client modify its own macro.