VBA-tools/VBA-Web

Health v2 · maintenance only

Adoption not part of the score

2135 stars · 498 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

VBA-Web is a VBA library that lets Excel, Access, and other Office applications call web services and REST APIs on Windows and Mac. It provides a WebClient with JSON parsing, cookies, headers, and built-in authentication support.

Use cases

• call rest apis from excel vba
• parse json responses in vba
• authenticate with oauth 2.0 from office macros
• pull data from web services into excel
• connect access to external apis
• make http requests from vba on mac and windows

When to choose

• you need to consume REST APIs from Excel, Access, or other VBA-hosted Office apps
• you want built-in OAuth, Basic, and Windows authentication in VBA
• you need cross-platform (Windows and Mac) VBA HTTP support

When to avoid

• you are working outside the VBA/Office ecosystem
• you need XML parsing on Mac, which is currently unsupported
• you are building a modern add-in where Office.js or a .NET/Python stack fits better

Facets

library · maturity maintenance

http-client serialization auth json apis web-development developer-tools windows cross-platform vba excel office rest web-services oauth microsoft-office automation macos

Member repositories

For agents

markdown · JSON · MCP: product_card(name="VBA-tools/VBA-Web")