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.