List Office files
xlide_list_projectsFind all Office and VBA project files in the workspace, returning absolute paths, host applications, and VBA openability, with reasons for files that cannot be opened.
Instructions
Finds the Office files in this server's workspace and returns their absolute paths, host application and whether their VBA can be opened. Call this first when the user has not named a file. Covers Excel (.xlsm, .xlsb, .xlam, .xls, and .xlsx for Power Query and sheets), Word (.docm, .dotm, .doc), PowerPoint (.pptm, .potm), Access (.accdb, .mdb), and Visual Basic 6 projects (.vbp, whose modules are the files its manifest names). Files whose extension is recognized but not openable are listed with the reason, so a template or add-in is not silently missing.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| subfolder | No | Limit the search to this folder. Empty searches every workspace root. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||