extract_vba - A utility to extract a VBA project from an Excel 2007+ xlsm file.
This utility is used to extract the VBA project binary from an Excel 2007+ xlsm file. The VBA project can then be added to an Excel::Writer::XLSX file to enable it to have macros.
xlsm file is a version of an Excel
xlsx file that contains an additional VBA project binary file. The
xlsm file format is a collection of mainly XML files in a ZIP container.
The extracted VBA project is an OLE Compound Document in binary format. It is named
vbaProject.bin and is generally located in the
xl directory of the
add_vba_project() section of the Excel::Writer::XLSX documentation for more details.
Note: you can also extract the VBA project from an
xlsm file using the standard Linux
unzip -j macro01.xlsm xl/vbaProject.bin
On Windows you can use any suitable Unzip application.
$ extract_vba file.xlsm Extracted 'vbaProject.bin' successfully $ extract_vba -h # For help.
John McNamara firstname.lastname@example.org
(c) MMXV, John McNamara.
All Rights Reserved. This program is free software. It may be used, redistributed and/or modified under the same terms as Perl itself.