I'm trying (in Java) to create a Excel file (.xlsm) with personnals macro in VBA.
The macros must be generated by Java code.
Is this possible ?
Apache POI (HSSF and XSSF) has limiMacros
Macros can not be created. The are currently no plans to support macros. However, reading and re-writing files containing macros will safely preserve the macros.y preserve the macros.
We can add a macro in a package for a dotx (xlsx-java-f15/adding-macro-xlsm-package-t727.html#p2287)
I also saw this topic too : docx-java-f6/inserting-macros-t238.html But it's for a Word (dotx, docm) document
I know that it's possible to set a VBA Project (vbaProject.bin) with (Apache POI), but is it possible to generate a vbaProject.bin file ?
Or generete macro directly with Java code ?
Macros are different for each generated Excel file, so it's impossible to create Macro into an Excel model (.xltm)
Thank you in advance and have a nice day