Skip to content

Instantly share code, notes, and snippets.

View AdrianoBortoloto's full-sized avatar

Adriano Bortoloto AdrianoBortoloto

  • Florianópolis - Brasil
View GitHub Profile
@AdrianoBortoloto
AdrianoBortoloto / ExportVisualBasicCode.bas.vb
Last active April 8, 2016 16:50 — 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
' Requires check "Microsoft Scripting Runtime" at Tools > References to use "FileSystemObject";
Public Sub ExportVisualBasicCode()
Const Module = 1
Const ClassModule = 2
Const Form = 3
Const Document = 100
Const Padding = 24