lunasoft2001 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
- routing-guide.md — detailed routing logic and file type detection.
- backup-policy.md — full backup policy, verification checklist, and rollback procedures.
Part of the Office VBA Suite · MIT License