Awesome VBA

Visual Basic for Applications (VBA) is an implementation of Microsoft's event-driven programming language Visual Basic 6.0 (VB6) built into most desktop Microsoft Office applications.

This is a curated list of Libraries and Resources for both VBA and VB6.

Because of the nature of VBA, many libraries do not work on all Operating Systems, in all Office Applications or on all architectures(x64/x86), therefore we use symbology. Read more about this here.

Contents

• Frameworks
• Libraries
• Data Formats (JSON, CSV, XML, etc.)
• Data Structures (Array-List and Dictionary)
• Math libraries
• Database tools
• Userform tools
• Low level tools
• Parsers / Interpreters
• Web tools
• Developer tools
• Examples
• Algorithms, code optimisation, and performance testing
• UI Ribbon
• UI Userforms
• Low level examples
• AddIns
• Games / Fun projects
• External tools
• Style Guides
• Information
• Resources
• Win32 API Resources
• VB6 / VBScript
• Websites
• Books
• YouTube
• Forums

---

Frameworks

• ![p_win] ![p_nom] ![a_all] stdVBA - A framework containing numerous classes for automation and utility. Focuses on code compactness and long-term maintainability.
• ![p_win] ![p_nom] ![a_all] ![o_32] VbCorLib - A framework which brings many powerful .NET classes to VBA/VB6.
• ![p_win] ![p_nom] ![a_all] Hidennotare - A framework by Japanese author RelaxTools. Contains numerous classes, interfaces and forms.

Libraries

Data Formats

JSON

• ![p_win] ![p_mac] ![a_all] VBA-FastJSON - Fast, cross-platform, native json parser and serializer. Memory efficient (non-recursive), RFC 8259 compliant, UTF8 support
• ![p_win] ![p_mac] ![a_all] VBA-JSON - JSON conversion and parsing.
• ![p_win] ![p_nom] ![a_all] mdJSON - JSON library with dot-notation for extracting paths.
• ![p_win] ![p_nom] ![a_all] JSONBag - Uses shebang notation to extract keys from JSON strings. Can also build JSON with this library.
• From Frameworks:
  • ![p_win] ![p_nom] ![a_all] In stdVBA find stdJSON - As above.

CSV

• ![p_win] ![p_mac] ![a_all] VBA-CSV-interface - Powerful, fast and comprehensive RFC-4180 compliant CSV/TSV/DSV data management library.
• From Frameworks:
• ![p_win] ![p_nom] ![a_all] In Hidennotare find csvWriter and csvReader.

XML

• ![p_win] ![p_mac] ![a_all] VBA-XML - XML conversion and parsing.

ZIP

• ![p_win] ![p_nom] ![a_all] Excel-ZipTools - Parse, read, and extract data from, Zip files. Written in pure vba.
• ![p_win] ![p_nom] ![a_all] vbaSquash - Compress and decompress files and byte arrays using the built-in cabinet.dll functions available on Windows 8+. Provides access to compression algorithms MSZIP, XPRESS, XPRESS_HUFF, and LZMS.