This project is read-only.

VBA Extractor 0.1

Rating: No reviews yet
Downloads: 240
Change Set: 5f7046811c74781
Released: May 16, 2013
Updated: May 16, 2013 by neildodson
Dev status: Beta Help Icon

Recommended Download

Source Code VbaExtractor 0.1 source
source code, 379K, uploaded May 16, 2013 - 140 downloads

Other Available Downloads

Application VbaExtractor 0.1 binaries
application, 155K, uploaded May 16, 2013 - 100 downloads

Release Notes

Overview:
This tool exports VBA code from Word or Excel as plain text source files. A Visual Basic 6.0 project is also created for good measure. The core logic for parsing the OLE file and decompressing the VBA elements is taken from the following resources by Tony Jollans, and coverted to .Net:

http://www.wordarticles.com/Articles/Formats/StructuredStorage.php
http://www.wordarticles.com/Articles/Formats/StreamCompression.php
http://www.wordarticles.com/Articles/Formats/dirStream.php

Usage
  • Extract the binaries to a new folder
  • Run the .exe
  • Set the source folder text field to the Office file you want to process.
  • Set the target folder to the location on disk you want to write the files to.
  • Click the button
  • Load the result in VB6 or a text editor

Requirements
  • .Net 4.0 runtime

Limitations
*Does not export the declarations of user interface elements in User Forms. The tool renders the VB source code for the form, including event handlers or any routines defined in it, but any references in that code to the actual buttons, textfields etc will stop the visual basic project from compiling

*Exported classes are marked (correctly) as not creatable, so compilation of the exported project will fail unless you add a public (MultiUse) class. If you're trying to use the actual dll for something, you'll need to change the classes so they can be created from an external COM client.

Reviews for this release

No reviews yet for this release.