Skip to content

Instantly share code, notes, and snippets.

View karayakar's full-sized avatar
🎯
Focusing

Karay Akar karayakar

🎯
Focusing
View GitHub Profile
@karayakar
karayakar / ExportVisualBasicCode.bas.vb
Created April 25, 2022 12:12 — 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
Public Sub ExportVisualBasicCode()
Const Module = 1
Const ClassModule = 2
Const Form = 3
Const Document = 100
Const Padding = 24
Dim VBComponent As Object