Programmatically export the VBA code from an Excel workbook

[Daryn]

Hi all,

I would like to programmatically export all the VBA code from an Excel file.
Preferably java, but any language will do.

I want to end up with a plain text file with all the code. This is what you get when you exprt the code from the VB Editor, but I want to do it automatically.

I also don't want to have to edit the VBA code in the original Excel file.

Thanks in advance

[Leith Ross]

Hello Daryn,

Welcome to the Forum!

I don't know of a way to export the data from a VBA project without using the VB Editor or inserting a macro into the VBA project to export the code. The other problem is the export feature creates individual files. It does not have an option to export into a single text file.

This basically leaves you with the option of having to use a macro. While a macro can export the code into a single text file, you run into problems if there are UserForms in the project. UserForm files have 2 parts the .frm file holds the code. The hidden file .frx holds binary information used to draw the form. The .frx file type is proprietary and exists with the Excel workbook. Unfortunately, this file is only accessible using the export feature of VBA.

[royUK]

I have an addin that exports all the code modules, forms etc to a folder. You can then use this to import the code to another workbook.

I'll check it out & see about finishing it

[snb]

Please Login or Register  to view this content.

[royUK]

This addin will Export all Code & Forms to a selected Directory,Import Code from a selected directory, delete all code from a selected workbook. Also shows a customised Toolbar to select FaceIds & store favourite Ids

When the addin is installed it will add a new menu item - Code Tools