Project Description
C# library to read Vba code / VBA Project information from VBProject.bin or regular Excel files. It has no requirements on MS Excel being installed on machine.

This project demonstrates how to read basic information from VBProject.bin binary files, e.g. to extract VBA Code & module information as plain text.

It contains an integration project with OpenXML, so the same can be done for regular Excel files without manually having to extract the VBProject files. As a result, it is possible to e.g. read VBA Code from Excel files without opening these in Excel (or even having Excel installed on the machine).

All code is full C#.

The project includes Example Code. Usage is as easy as

using(var vbProject = new VbProject(@"C:\your-file.xlsm"))
foreach(var vbModule in vbProject.Modules)
Console.WriteLine("Found module {0} with code {1}", vbModule.Name, vbModule.Code);

Last edited Nov 25, 2016 at 1:08 PM by BogeyCode, version 3