1EXTRACT_VBA(1)        User Contributed Perl Documentation       EXTRACT_VBA(1)
2
3
4

NAME

6       extract_vba - A utility to extract a VBA project from an Excel 2007+
7       xlsm file.
8

DESCRIPTION

10       This utility is used  to extract the VBA project binary from an Excel
11       2007+ xlsm file. The VBA project can then be added to an
12       Excel::Writer::XLSX file to enable it to have macros.
13
14       An "xlsm" file is a version of an Excel "xlsx" file that contains an
15       additional VBA project binary file. The "xlsm" file format is a
16       collection of mainly XML files in a ZIP container.
17
18       The extracted VBA project is an OLE Compound Document in binary format.
19       It is named "vbaProject.bin" and is generally located in the "xl"
20       directory of the "xlsm" file.
21
22       See the "add_vba_project()" section of the  Excel::Writer::XLSX
23       documentation for more details.
24
25       Note: you can also extract the VBA project from an "xlsm" file using
26       the standard Linux "unzip" command:
27
28           unzip -j macro01.xlsm xl/vbaProject.bin
29
30       On Windows you can use any suitable Unzip application.
31

SYNOPSIS

33           $ extract_vba file.xlsm
34           Extracted 'vbaProject.bin' successfully
35
36           $ extract_vba -h # For help.
37

OPTIONS

39       --help or -h
40           Print the help documentation.
41

AUTHOR

43       John McNamara jmcnamara@cpan.org
44

VERSION

46       Version 0.01.
47

49       (c) MMXV, John McNamara.
50
51       All Rights Reserved. This program is free software. It may be used,
52       redistributed and/or modified under the same terms as Perl itself.
53
54
55
56perl v5.32.1                      2021-01-27                    EXTRACT_VBA(1)
Impressum