B4J Question vba macro from b4j

[aziznetstudio]

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

 

[Erel]

Moved to the questions forum.
You cannot run macros externally.

 

[PaulMeuris]

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.