Search VBA
xlide_search_modulesSearch all VBA module sources in an Office file for a text or regex query, returning each match with module, line number, and line content. Use it to locate every declaration or usage of a name before renaming it.
Instructions
Searches every module's source in an Office file and returns each match with its module, line number and the line itself. Use it to find where a name is declared or used before changing it. Plain text by default; set is_regex for a Python regular expression.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | Text or pattern to find. | |
| is_regex | No | Treat query as a regular expression. | |
| file_path | Yes | Absolute path to the Office file. | |
| match_case | No | Match case. Off by default, because VBA itself ignores case. | |
| max_results | No | Stop after this many matches. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||