Or compile VB file to .exe in Perl?
I am using the unzip command to extract the VBA-bin from the sample XLSM excel file.
unzip -j xl/sample.xlsm xl/vbaProject.bin
I have the same macro code in the sample.vb file in a git directory. I am generating the XLSM files using Perl script and adding vbaProject.bin in those generated files using
$workbook->add_vba_project( '/home/pathtosharedtemplatefolder/vbaProject.bin' );
I am planning to update the sample.vb file in "pathtosharedtemplatefolder" directory. So I can compile the sample.vba file locally to generate the bin file for the formatting of the sheet rather than using the project.bin file itself. This way I also can keep track of the sample.vb files update with git diff for debug purposes.
Or
what is Linux command/PERL code to compile the VBA to project-bin?