The newly approved Python Enhancement Proposal 751 gives Python a standard lock file format for specifying the dependencies of projects. Here’s the what, why, and when.

Overall, the choice between VBA and Python for Excel automation depends on your specific needs. Even though it's outdated, ...

Human-readable and machine-generated lock file will specify what direct and indirect dependencies should be installed into a Python environment.