vba-parts

vba's code snippets, helper functions, mini tools

File I/O

MFileSystem.bas - Read/Write Text File

• Early Binding
• Late Binding
• Late Binding without explicit type declaration

Reference

Microsoft Scripting Runtime

• Scripting.FileSystemObject

MFile.bas - Read/Write Text File

• Early Binding
• Late Binding
• Late Binding without explicit type declaration

Reference

Microsoft Scripting Runtime

• Scripting.File

MADODBStream.bas - Read/Write Text/Binary File

• Early Binding
• Late Binding
• Late Binding without explicit type declaration

Reference

Microsoft ActiveX Data Objects X.X Library

• ADODB.Stream

File System

MFileSystem.bas - Create Folder

• Early Binding
• Late Binding
• Late Binding without explicit type declaration

Reference

Microsoft Scripting Runtime

• Scripting.FileSystemObject

MFolder.bas - Get Folders/Files

• Early Binding
• Late Binding
• Late Binding without explicit type declaration

Reference

Microsoft Scripting Runtime

• Scripting.Folder

Network

MXMLHTTP.bas - HTTP GET/POST

• Early Binding
• Late Binding
• Late Binding without explicit type declaration

Reference

Microsoft XML, vX.X

• MSXML2.XMLHTTP

Text String

MRegExp.bas - Regular Expression - Test/Execute/Replace

• Early Binding
• Late Binding
• Late Binding without explicit type declaration

Reference

Microsoft VBScript Regular Expression 5.5

• VBScript_RegExp_55.RegExp

MHTMLDocument.bas - JSON - Parse

• Early Binding
• Late Binding
• Late Binding without explicit type declaration

Reference

MXMLDOM.bas - Base64/Binary, Hex/Binary - Encode/Decode

• Early Binding
• Late Binding
• Late Binding without explicit type declaration

Reference

Microsoft XML, vX.X

• MSXML2.DOMDocument
• XDR Schema Data Types

Dialog Box

MExcelApp.bas - File/Folder Dialog Box

• Early Binding
• Late Binding
• Late Binding without explicit type declaration

Reference

Microsoft Excel X.X Object Library

• Excel.Application
• Office.FileDialog

Tools

SpdxLicenseText.bas - RegExp Matching Pattern Generator

• Early Binding
• Late Binding
• Late Binding without explicit type declaration

SpdxLicenseTemplateText.bas - RegExp Matching Pattern Generator

• Early Binding
• Late Binding
• Late Binding without explicit type declaration