How to export code from a text editor in the main workbook to a text editor for many files

Hello everyone
I have searched in this wonderful Forum and found this file
I need help in just one point
How can add a line in the same code to export the codes in Module NO 2 to the text editor In all the files that have been created
Hope it is clear
Thanks advanced for help

If I understood you well: Yes, it is.

First of all you shall SaveAs with fileformat 52 not 51

51 is xlOpenXMLWorkbook (without macro's in 2007-2016, xlsx)
52 is xlOpenXMLWorkbookMacroEnabled (with [or without] macro's in 2007-2016, xlsm)

Second you have to enable VBA access to Project Object model. Two actions are needed:
* VB Editor > Tools > References > (Check) Microsoft Visual Basic for Applications Extensibility 5.3
* File -> Options -> Trust Center -> Trust Center Setttings -> Macro Settings -> Trust Access to the VBA Project object model.

And having these requirements completed, you could use code similar to the one from here: https://stackoverflow.com/questions/...other-workbook to write module into the file

If you successfully changed Trust Access to VBA model and marked reference as checked, then code part in your Module1 is as follows:

Please Login or Register  to view this content.

See also attached file - I tested it and it prepares set of 8 new xlsm files with Module2 inside.

The issue with files created before is that these files are in xlsx format (not enabled macros). So these files shall be first converted into xlsm format, possibly with adding a module to each of them.

Here is example procedure to do it (copy it into your module 1 (and remember to make a backup copy of original xlsx files in case something goes wrong during this conversion):

Please Login or Register  to view this content.

And after running this, your files will be xlsm type and will contain all Module2 code inside