Option Explicit

Category: VBA

  • Export Modules to Folder

    Export Modules to Folder

    —

    by

    Keith
    in , ,

    This will create a folder using the base name of your Excel file, which is the filename without its extension, along with a vba subfolder. Your VBA modules will be placed there. Set Reference to Microsoft Visual Basic for Applications Extensibility Sub ExportModules( _ Optional PathToVBAModules As String = “” _ ) Dim objMyProj As…