Skip site navigation (1)Skip section navigation (2)

FreeBSD Manual Pages

  
 
  

home | help
EXTRACT_VBA(1)	      User Contributed Perl Documentation	EXTRACT_VBA(1)

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

DESCRIPTION
       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.

       An "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	"xlsm" file.

       See 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" command:

	   unzip -j macro01.xlsm xl/vbaProject.bin

       On Windows you can use any suitable Unzip application.

SYNOPSIS
	   $ extract_vba file.xlsm
	   Extracted 'vbaProject.bin' successfully

	   $ extract_vba -h # For help.

OPTIONS
       --help or -h
	   Print the help documentation.

AUTHOR
       John McNamara jmcnamara@cpan.org

VERSION
       Version 0.01.

COPYRIGHT
       (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.

perl v5.24.1			  2016-04-30			EXTRACT_VBA(1)

NAME | DESCRIPTION | SYNOPSIS | OPTIONS | AUTHOR | VERSION | COPYRIGHT

Want to link to this manual page? Use this URL:
<https://www.freebsd.org/cgi/man.cgi?query=extract_vba&sektion=1&manpath=FreeBSD+12.1-RELEASE+and+Ports>

home | help