Vbaexcel
VBAExcel generates and modifies VBA code for Excel, automating tasks and streamlining spreadsheet operations efficiently.
Install on your platform
We auto-selected Claude Code based on this skill’s supported platforms.
Run in terminal (recommended)
claude mcp add vbaexcel npx -- -y @trustedskills/vbaexcel
Or manually add to ~/.claude/settings.json
{
"mcpServers": {
"vbaexcel": {
"command": "npx",
"args": [
"-y",
"@trustedskills/vbaexcel"
]
}
}
}Requires Claude Code (claude CLI). Run claude --version to verify your install.
About This Skill
What it does
This skill allows AI agents to interact with Microsoft Excel spreadsheets using VBA (Visual Basic for Applications) code. It can automate tasks such as data manipulation, report generation, and complex calculations within Excel files. The agent can execute VBA scripts directly or generate them based on user instructions.
When to use it
- Automating repetitive Excel-based reporting processes.
- Performing complex data analysis that requires custom formulas or macros.
- Generating dynamic charts and graphs from spreadsheet data.
- Modifying existing spreadsheets based on external data sources or conditions.
Key capabilities
- VBA script execution within Excel.
- Generation of VBA code snippets.
- Data manipulation using VBA functions.
- Report generation via VBA macros.
Example prompts
- "Run the 'CalculateSales' macro in my SalesData.xlsx file."
- "Generate a VBA script to sum column B and display it in cell A1 of Sheet1."
- "Create a macro that filters rows based on values in column C."
Tips & gotchas
- Requires access to Microsoft Excel and the relevant spreadsheet files.
- VBA code can be complex; ensure the agent has sufficient context or instructions for accurate script generation/execution.
Tags
TrustedSkills Verification
Unlike other registries that point to live repositories, TrustedSkills pins every skill to a verified commit hash. This protects you from malicious updates — what you install today is exactly what was reviewed and verified.
Security Audits
| Gen Agent Trust Hub | Pass |
| Socket | Pass |
| Snyk | Pass |
🌐 Community
Passed automated security scans.