# VBA MCP Server

> VBA MCP Server — xiongchenghou-vba-mcp-server. Use this tool when you need to automate interactions with Excel workbooks using VBA code, solving problems of manual data transfer and synchronization. It enables AI assistants to directly read and write VBA code via COM, accepting inputs such as workbook paths and code snippets, and outputting modified workbooks or executed code results. Ideal for use cases requiring seamless integration of AI-driven automation with Excel-based workflows.

Canonical page: https://skillsregistry.net/skills/xiongchenghou-vba-mcp-server  
JSON: https://api.skillsregistry.net/v1/skills/xiongchenghou-vba-mcp-server

## Description

Enables AI assistants to directly read and write VBA code in Excel workbooks via COM, eliminating manual export/import cycles.

## Trust

- **Trust score (0–1):** 0.69
- **Verification tier:** scanned
- **Last scanned:** 2026-08-29

## Facts

- **Version:** 1.0.0
- **Skill type:** atomic
- **Execution layer:** mcp-remote
- **Runtime environment:** api
- **Category:** other
- **Updated:** 2026-08-29

## Source

- **Source listing:** [Glama](https://glama.ai/mcp/servers/cpy1oo1wkr)
- **Repository:** <https://github.com/xiongchenghou/vba-mcp-server>

## Use it

Resolve this record through the SkillsRegistry MCP server (no auth, read-only):

```
claude mcp add --transport http --scope user skillsregistry https://api.skillsregistry.net/mcp
```

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "get_skill",
    "arguments": {
      "slug": "xiongchenghou-vba-mcp-server"
    }
  }
}
```

REST: `GET https://api.skillsregistry.net/v1/skills/xiongchenghou-vba-mcp-server` · pull for local use: `GET https://api.skillsregistry.net/v1/skills/xiongchenghou-vba-mcp-server/pull`

---
SkillsRegistry indexes agent skills from public registries and GitHub. Skills we have analysed are scanned with Circle-IR and scored on six dimensions; each listing states its scan coverage. More: https://skillsregistry.net/llms.txt