This project has moved. For the latest updates, please go here.

EPPLUS - Execute a VBA macro from runtime

Aug 2, 2014 at 1:16 PM
First of all, thanks so much for creating and maintaining a such a good tool. We got the assignment of re-engineering a set of reports that were developed by using MS Office Interop and VBA code. those reports are supposed to be executed on daily basis and taking around 4 hours to execute. Basically the idea is to get the daily average for 5000 KPIs from a real-time-database system. After a long research, i found EPPLUS and was able to reduce the execution time to almost 10 min. The problem i am facing now is that the Excel files has some VBA code that needs to be executed, migrating them .NET will take too much time, and i cannot find a way to execute the code from my EPPLUS Class and generate the PDF. Any help will be appreciated!
Aug 6, 2014 at 8:51 AM
Sorry - it is not possible to execute VBA code via EPPlus.