Skip to content

Instantly share code, notes, and snippets.

@marcucciboy2
marcucciboy2 / ExportVisualBasicCode.bas.vb
Last active January 2, 2018 16:38 — forked from steve-jansen/ExportVisualBasicCode.bas.vb
Excel macro to export all VBA source code in this project to text files for proper source control versioning
' Excel macro to export all VBA source code in this project to text files for proper source control versioning
' Requires enabling the Excel setting in Options/Trust Center/Trust Center Settings/Macro Settings/Trust access to the VBA project object model
' changes:
' - only exports normal modules
' - uses mkdir instead of fso
' - does not use statusbar
Public Sub ExportVisualBasicCode()