| name | office-vba-orchestrator |
| description | Route Office VBA tasks to the correct per-application skill (vba-word, vba-powerpoint, vba-access, vbaExcel) and enforce the mandatory backup-before-import policy for all Office macro-enabled files. Use when the user mentions any Office VBA task without specifying which skill to use, when working with mixed Office file types, or when you need to remind the user of the backup policy. Explicitly excludes Outlook VBA. Triggers on: Office VBA, VBA suite, which VBA skill, office macros, VBA workflow, extraer VBA Office, importar VBA Office, macros Office, .xlsm .docm .pptm .accdb VBA, suite VBA, orchestrate VBA skills. |
office-vba-orchestrator
Detect the target Office application and route to the correct VBA skill, always enforcing the backup-first policy.
⚠️ Universal Backup Policy (Mandatory)
No import, overwrite, or destructive operation without a verified backup.
If the user has not confirmed a recent backup, stop the flow and perform the backup step first before proceeding with any import or rewrite.
This policy applies to ALL skills in the Office VBA suite.
Routing Table
| File type | Application | Skill to activate |
|---|
.xlsm, .xlam, .xltm | Excel | vbaExcel |
.docm, .dotm | Word | vba-word |
.pptm, .potm | PowerPoint | vba-powerpoint |
.accdb, .mdb | Access | vba-access |
Outlook (.otm) | — | ❌ Not supported — excluded from this suite |
Decision Flow
1. Identify file type from user message or file path
2. Check routing table → select skill
3. Verify backup exists → if not, pause and backup first
4. Delegate to the selected skill's recommended workflow:
healthcheck → backup → export → refactor → import → validate
Per-Skill Quick Reference
vbaExcel — Excel .xlsm
- Export:
python scripts/export_vba.py workbook.xlsm ./exported_vba/
- Import:
python scripts/import_vba.py workbook.xlsm ./exported_vba/ (backup first)
- Enable VBOM:
scripts/enable_vba_access.reg
vba-word — Word .docm
- Export:
python scripts/export_vba_word.py MyDoc.docm ./exported_vba/
- Import:
python scripts/import_vba_word.py MyDoc.docm ./exported_vba/ (backup automatic)
vba-powerpoint — PowerPoint .pptm
- Export:
python scripts/export_vba_ppt.py Deck.pptm ./exported_vba/
- Import:
python scripts/import_vba_ppt.py Deck.pptm ./exported_vba/ (backup automatic)
vba-access — Access .accdb (VBA modules only)
- Export:
python scripts/export_vba_access.py MyApp.accdb ./exported_vba/
- Import:
python scripts/import_vba_access.py MyApp.accdb ./exported_vba/ (backup automatic)
- Full DB analysis: use access-analyzer instead
Backup Command (Universal)
# Works for any Office file
$file = "path\to\YourFile.xlsm" # or .docm / .pptm / .accdb
Copy-Item $file ($file -replace '\.\w+$', "_BACKUP_$(Get-Date -f 'yyyyMMdd_HHmmss')$([System.IO.Path]::GetExtension($file))")
Common Scenarios
"I want to refactor VBA in my Excel workbook" → Use vbaExcel.
"Export macros from my Word document" → Use vba-word.
"Edit PowerPoint slide macros in VS Code" → Use vba-powerpoint.
"Clean up Access VBA modules" → Use vba-access (VBA only) or access-analyzer (full DB).
"I have an .xlsm and a .docm to process" → Run each skill independently; backup both files first.
References
Part of the Office VBA Suite · MIT License
