aziznetstudio Member Jun 29, 2024 #1 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
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 B4X founder Staff member Licensed User Longtime User Jun 30, 2024 #2 Moved to the questions forum. You cannot run macros externally. Upvote 0
P PaulMeuris Well-Known Member Licensed User Jul 1, 2024 #3 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
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.