admin/VBAExtractor
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
20 Commits 1 Branch 0 Tags
main
Commit Graph

10 Commits

Author SHA1 Message Date
Misaka_Company
585a9ed7f3 refactor: use VBA-Excel/VBA-Access as default output dirs by file type 
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
 2026-05-11 10:01:37 +08:00
Misaka_Company
d156fdb2d8 fix: address code review issues for Access support 
- Fix import_vba_access() to actually save database via DoCmd.Save()
- Update stale module docstring in extract_vba.py
- Validate file extensions in get_file_type() instead of silently
  defaulting to excel
- Scan both Excel/ and Access/ directories in interactive mode

Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
 2026-05-11 09:44:55 +08:00
Misaka_Company
df81562dd9 feat: add Access (.accdb) extraction support to extract_vba.py 
Co-Authored-By: Claude Opus 4.6 <noreply@anthropic.com>
 2026-05-11 09:37:32 +08:00
Misaka_Company
ab01835b06 refactor: export form modules as .frm files to align with VBA conventions 
Change form module export from .cls to .frm extension to match standard VBA file conventions and align with import_vba.py expectations. This eliminates ambiguity between class modules and form modules.

Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
 2026-03-19 15:47:57 +08:00
Misaka_Company
59f0ef2125 refactor: remove metadata generation and add configurable output directory 
- Remove vba_metadata.json generation logic to simplify extraction process
- Add VBA_OUTPUT_DIR configuration to allow custom output path
- Update output directory priority: parameter > env var > source file directory
- Clean up unused imports and remove _save_metadata method

Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
 2026-02-03 12:47:54 +08:00
Misaka_Company
3569c76e53 fix: skip empty VBA modules during extraction to avoid creating unnecessary files 
- Add check in _process_module() to detect modules with no actual code content
- Display skip message for empty modules instead of creating files
- Prevent empty modules from being added to metadata

Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
 2026-01-28 11:24:01 +08:00
Misaka_Company
69b92884a1 refactor: migrate configuration to .env file for better environment management 
- Replace hardcoded file paths with environment variables in extract_vba.py and import_vba.py
- Add .env file for local configuration (excluded from git via .gitignore)
- Add python-dotenv dependency for environment variable loading
- Maintain fallback to interactive mode when environment variables are not set

Co-Authored-By: Claude Sonnet 4.5 <noreply@anthropic.com>
 2026-01-28 11:20:50 +08:00
Misaka_Company
5bc1dbc3f5 add: enhance TARGET_XLSM_FILE configuration and improve file selection process in extract_vba.py 2026-01-20 08:38:19 +08:00
Misaka_Company
33ae440f6e fix: improve line handling in VBA code extraction to avoid extra blank lines 2026-01-19 17:31:07 +08:00
Misaka_Company
75c90937fa add extract_vba.py for VBA code extraction and update requirements.txt 2026-01-19 16:13:52 +08:00