Export all modules dynamically to folder

Is there a way to export copies of all modules from a workbook with VBA (would like to be able to run from personal workbook)? I would like to avoid having to export them individually if possible. I have searched intensely and seen multiple posts about exporting to another workbook, but I want them on my computer in the project file. Thanks in advance for any help!

The macro would check if a folder exists ("Macros")

• If it does, place the macros in the folder
• Any already exist, ask before overwriting
• If it does not, create folder then add to
• The folder would be created on the same level as the Development folder I am working in.
• This would all be based on the Active workbook, so no hardcoded path to constantly change

For each report I do, the following folders exist, with excepting of the Macros on most.

• Development Templates
• ^Macros
• Other
• Reports - Weekly
• Reports - Monthly

Fluff13,

It seemed to be what I needed. I added it to a new module in my personal workbook. I have one workbook open, and it contains 8 modules. But I received the "Export is ready" messagebok, and nothing else happened. What did I do wrong?

Fluff13,

I just discovered that and was about to come tell you I found them. Can you help me modify the path (dynamically) where it will let me choose the location, and it will have a starting point of where ever my active file is? Since I work multiple projects having one master folder for all VBA modules is not something beneficial, especially as most projects have similar module names, even though the subs are not always the same (m_Save, m_Format, m_Copy for example). That would be a huge help. Thanks

Fluff13,

I heed your warning. I made the changes (thanks for such clear instructions). But when I ran it, I got the "Export Folder not exist" message. Now, I am confused, as when this was saving to the documents folder, if the VBAProjectFiles folder did not exist, it was created, yet now that it is in a new location, it gives me an error.

It is located on onedrive (i HATE onedrive). We are forced to work out of onedrive rather than from our personal hard drive. When I copy the file path (shown in the screenshot). The portions in red are changed from the actual portions of this path to their generic equivalent. This is what is displayed:

C:\UserData\username\OneDrive - Company Name\Documents\CAPA\Incident Management v2\Reporting\KPI Reports

The folder marked "Development - Macros" was when I manually did this, each module, one at a time.

Fluff13,

Okay np, I wish I wasn't forced to. What about "Plan B"... instead of defaulting to the active path, which is what I want, Is there a way for me to browse to select the location, then the VBAProjectFiles would be created there?

Fluff13,

I tried that, and the browse dialog appeared, and it all seemed to work. But when I ran it a 2nd, 3rd, and 4th time (even on different projects), no browse dialog box appeared and it just overwrote the files (as you warned) in the previous location.

I feel what I may need to do is to use the My Documents folder, as this script was originally written and manually move the folder to my active project. That will allow me to make sure the macros are where they should be (on OneDrive), and if there is any overwriting of files it is because I want there to be.

As usual, Fluff13, you have been a tremendous help! Thank you so very much for all your help, it is greatly appreciated!!!!