VBA's biggest weakness is that its open source community and ecosystem is non-existent, so you always end up remaking the wheel. It's just easier making either python or javascript the default franca lingua.
imo that’s worse than python’s largely solved dependency management issues. Most people just use conda and it’s good enough. Is it as good as competing languages? No, but it’s still better than VBA’s ecosystem (including your solution) by miles. That said, I think it’s awesome that you’re still supporting VBA veterans since MS left them out in the cold.
That's a separate issue from dependency management entirely. Check out Repl.it's universal package manager if you want an idea of how we are solving the problem.
VBA's biggest weakness is that its open source community and ecosystem is non-existent, so you always end up remaking the wheel. It's just easier making either python or javascript the default franca lingua.