A repo for my daily use VBA utilities. You can download all scripts from vba-utils.xlam, or download the modules from the ./src folder.
Helper Module ./src/modHelper.bas
Call importModules
Import VBA components from ./src/modules, ./src/forms, ./src/classes into VBA Project.
Call exportModules
Export VBA components from VBA project to ./src/modules, ./src/forms, ./src/classes.
VBA Standard Modules ./src/modules/*.bas
VBA modules
VBA Class Modules ./src/classes/*.cls
VBA Class Modules
clsJson A JSON like class module, read data from an Excel sheet and store to the JSON like object.
Public Sub DEMO_JSON()
' Let's say we have a sheet named "Users" and have headers "ID", "Name", "Age", "Email" at row 1
Dim users As New clsJson
Call users.init(sheetName:="Users", keyColumnName:="ID", headerRowIndex:=1)
' get user data
Debug.Print "Name:" & Space(4) & users.getValue(key:="1", columnName:="Name")
Debug.Print "Email:" & Space(4) & users.getValue("1", "Email")
Debug.Print "Age:" & Space(4) & users.data("1")("Age")
End Sub
VBA Form Modules ./src/forms/*.frm
VBA Form Modules