GSP
Quick Navigator

Search Site

Unix VPS
A - Starter
B - Basic
C - Preferred
D - Commercial
MPS - Dedicated
Previous VPSs
* Sign Up! *

Support
Contact Us
Online Help
Handbooks
Domain Status
Man Pages

FAQ
Virtual Servers
Pricing
Billing
Technical

Network
Facilities
Connectivity
Topology Map

Miscellaneous
Server Agreement
Year 2038
Credits
 

USA Flag

 

 

Man Pages


Manual Reference Pages  -  EXTRACT_VBA (1)

.ds Aq ’

NAME

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

CONTENTS

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

<B>--help or -hB> 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.

Search for    or go to Top of page |  Section 1 |  Main Index


perl v5.20.3 EXTRACT_VBA (1) 2015-01-30

Powered by GSP Visit the GSP FreeBSD Man Page Interface.
Output converted with manServer 1.07.