Skip to main content
Glama
WilliamSmithEdward

xlide-excel-word-powerpoint-access-office-vba-mcp

Add or remove a project reference

xlide_manage_reference
DestructiveIdempotent

Add or remove VBA type library references to resolve missing-library errors and enable early binding in Office files.

Instructions

Adds or removes a type library reference in a VBA project and saves the file. Use it when xlide_analyze reports missing-library-reference, or when code needs early binding, as Dim d As Scripting.Dictionary does. Name the library: Excel, Word, PowerPoint and Access work anywhere, and on Windows any library the VBA editor's References dialog lists resolves by its description (Microsoft Scripting Runtime) or by the name code writes (Scripting), taking its GUID, version and path from this machine's registry. A name that matches several libraries is refused with the candidates. Off Windows, pass guid and version. Adding the host's own library, or removing Microsoft Forms while a UserForm exists, is refused: the first is implicit and the second stops the project compiling.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
guidNoFor add: the library's GUID, when it is not registered on this machine. library is then the name the reference is recorded under.
actionYes'add' or 'remove'.
libraryYesFor add: the library's description, the name code uses, or Excel, Word, PowerPoint or Access. For remove: the name xlide_list_references reports, or the GUID.
versionNoFor add with guid: major.minor in hexadecimal, as the registry spells it, such as 1.0 or 2.8. Empty takes the newest registered, or 1.0.
file_pathYesAbsolute path to the Office file.
allow_protectedNoAsk the user first.
allow_invalidate_signatureNoAsk the user first.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Schema Changelog

Changes observed during successful MCP inspections.

  1. Addedv1.1.0

TDQS

A4.7/5.0
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Beyond the destructiveHint annotation, the description discloses concrete behavioral details: it always saves the file, resolves library names primarily on Windows, rejects ambiguous matches, and refuses specific destructive mutations like removing Microsoft Forms while a UserForm exists. This gives the agent accurate expectations for edge cases.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is dense but every sentence carries necessary information: core action, use cases, naming resolution, refusal conditions, and platform requirements. It is front-loaded with the primary verb and resource, and the added complexity is justified for a tool with this many edge cases.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

For a 7-parameter tool with an output schema and fully documented parameters, the description still adds what the schema cannot: workflow triggers, naming resolution behavior, platform differences, and failure refusal conditions. It is complete enough for an agent to invoke it correctly in both common and exceptional cases.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so the baseline is 3. The description adds valuable cross-parameter meaning by explaining how the library parameter is interpreted ('Excel, Word, PowerPoint and Access work anywhere' or 'by the name code writes'), and when guid/version become necessary ('Off Windows, pass guid and version').

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description states a specific action ('Adds or removes a type library reference in a VBA project') and clearly indicates the file is saved. It distinguishes this from sibling tools like xlide_list_references by focusing on mutation rather than inspection.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description gives explicit triggers: 'when xlide_analyze reports missing-library-reference' and 'when code needs early binding, as Dim d As Scripting.Dictionary does.' It also covers important conditions like platform-specific requirements and refusals, though it does not explicitly name an alternative tool for inspection-only tasks.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.