Skip to content

Latest commit

 

History

History
51 lines (37 loc) · 2.5 KB

README.md

File metadata and controls

51 lines (37 loc) · 2.5 KB

Rubberduck Export All Utility

Version 2.0 August 24, 2023 Added error logging.

Rubberduck utility to export all components in the active project according to the Rubberduck @Folder annotation.

Required references: VBIDE (Microsoft Visual Basic for Applications Extensibility 5.3)

Dependenicies

Usage

May also enter in the immediate window and run the eg. RubberduckUtility.ExportAll "C:\VBA\Output"

Public Sub RubberduckExportProject()
   RubberduckUtility.ExportAll "C:\VBA\Output"
   RubberduckUtility.ErrorReport Critical
   Debug.Print
   RubberduckUtility.ErrorReport Warning
   Debug.Print
   RubberduckUtility.SummaryReport
End Sub

Output Example to immediate window

Warning invalid Rubberduck folder characters, <Rubberduck Utilities> RubberduckUtility.cls exported to C:\VBA\Output
Warning invalid Rubberduck folder characters, <Rubberduck Utilities> RubberDuckExport.bas exported to C:\VBA\Output

Total files exported to C:\VBA\Output : 216
Total warnings: 2
Total failed exports : 0

RubberduckUtility.ExportAll exports all components to the working directory provided for the active project. Sub folders are created according to the according to Rubberduck @Folder annotation and existing files are overwritten.

Added error handling for:

Invalid working directory.

  • Error is raised. The working directory must already exist.
  • Critical Errors logged for failed exports. This may occur if files attempting to overwrite are read-only or don't have permission.
  • Warnings logged for Rubberduck @Folder annotations that contain invalid folder characters. They are exported to the output directory provided.