/excel-macros-extractor

A program that extracts the VBA code from an Excel file and outputs it as a .bas raw file.

Primary LanguagePython

excel-macros-extractor

A program that extracts the VBA code from an Excel file and outputs it as a .bas raw file.

Usage

This program can take a batch of Excel Macro files (.xlsm) with VBA Code and outputs for each VBA code a .bas file containing that code.

  1. Specify the main directory where the .xlsm files are located.
  2. Specify the route of the output .bas files
  3. Run:
python extractMacros.py