B4J Question vba macro from b4j

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
 

PaulMeuris

Well-Known Member
Licensed User
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.
 
Upvote 0
Cookies are required to use this site. You must accept them to continue using the site. Learn more…