pyvba 0.6.0 alpha

This update, Total Rework, aims to completely rework the pyvba library to...make it better. There were several issues with the previous version, and this version is much more stable.

The following changes have been made:

• Added a method for Viewer-to-Browser conversion
• Fixed most, if not all, of the stack overflow issues
• Fixed the formatting for XML and JSON files
• Added a convenient dictionary method of viewing objects
• Several bug fixes:
  • [Resolves #6] Pyvba should work with more applications now
  • [Resolves #9] Kwargs were eliminated or defined in docstrings
  • [Resolves #11] Added from_viewer that allows for type conversion
  • [Resolves #12] IterableFunction class was recreated as CollectionViewer
  • [Resolves #13] Excel should no longer have stack overflow errors in many cases
  • [Resolves #14] JSON formatting was fixed

pyvba v0.5.1 alpha

• Added links to some shield banners in README.md
• Improved GitHub Actions slightly
• Added dependencies to setup.py

pyvba 0.5.0 alpha

The pyvba package was designed to gather data from VBA-based applications (e.g. Microsoft Excel, CATIA, etc.). It may also be used to assist programming VBA macro scripts in a more sensical language.

Getting Started

Install the Python Package:

pip install pyvba

To export data from a VBA program:

import pyvba

catia = pyvba.Browser("CATIA.Application")
active_document = catia.ActiveDocument

exporter = pyvba.XMLExport(active_document)
exporter.save("output", r"C:\Documents")

The currently supported output types are XML and JSON formats.

Developer Notes

This package is still in alpha. Hence, there are still some problematic bugs and issues that cause errors in certain applications. Contributors are welcome! The project is hosted on GitHub. Report any issues at the issue tracker, but please check to see if the issue already exists!