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