How williamsmithedward/pyopenvba works
pyOpenVBA edits VBA projects and Power Query content inside Office packages without requiring Office. The main workflow is to open or create a host file, inspect or change its code, forms, references, or queries, then save it for reopening in the host. Excel also has a workbook-backed formula calculator; VBA object/runtime support and shared compound-file handling are internal layers. README relationships are used for the documented public workflows; unsampled implementation links are omitted where their call direction is uncertain.
Main entry points: excel.py ExcelFile · vba.py VBA projects · word.py WordFile · powerpoint.py PowerPointFile
Components 15
Office VBA hosts
- ExcelFile
src/pyopenvba/excel.py - WordFile
src/pyopenvba/word.py - PowerPointFile
src/pyopenvba/powerpoint.py - AccessDatabase
src/pyopenvba/access/database.py - VBA projects
src/pyopenvba/vba.py - UserForms
src/pyopenvba/forms.py
Excel capabilities
- Excel workbook model
src/pyopenvba/apps/excel/_model.py - Formula workbook bridge
src/pyopenvba/apps/excel/_engine_book.py - Formula engine
src/pyopenvba/formula/_calc
Power Query
- Power Query workbook
src/pyopenvba/powerquery/workbook.py
Language runtime
- VBA interpreter
src/pyopenvba/interpreter/_runtime.py - VBA object model
src/pyopenvba/interpreter/_objects.py
Package internals
- Compound files
src/pyopenvba/cfb.py
Other components
- Python user
- Office applications
Connections 19
- Python user → ExcelFile: opens or creates
- Python user → WordFile: opens or creates
- Python user → PowerPointFile: opens or creates
- Python user → AccessDatabase: opens or creates
- Python user → Power Query workbook: opens or creates
- ExcelFile → VBA projects: edits VBA
- WordFile → VBA projects: edits VBA
- PowerPointFile → VBA projects: edits VBA
- AccessDatabase → VBA projects: edits VBA
src/pyopenvba/access/database.py - ExcelFile → UserForms: edits forms
- ExcelFile → Excel workbook model: edits workbook
- Formula workbook bridge → Formula engine: adapts workbook
src/pyopenvba/apps/excel/_engine_book.py - Power Query workbook → Office applications: saves for reopening
- ExcelFile → Office applications: saves for reopening
- WordFile → Office applications: saves for reopening
- PowerPointFile → Office applications: saves for reopening
- AccessDatabase → Office applications: saves for reopening
- VBA interpreter → VBA object model: dispatches members
- VBA projects → Compound files: reads and writes
src/pyopenvba/vba.py