Hi every b4xien developers
im developing an app in b4j, and i have an xlsm excel file with a lot of macro created in vba
so, how to run vba macro directly from my app using xlutils or Jacob or any other way ?
thank you all
You could use a Powershell script that you can run using the jShell library from B4J. calling-excel-macros-from-powershell-with-arguments
In my latest B4J example pmfiles i am using the technique described to convert an Excel file to a PDF document.
Modify the script and you can run the macro's.
Let me know if you need some assistance.