Here’s an example where Excel VBA was integrated with OpenSSL and python that provided an auto login feature, in this case, into Betfair’s API to retrieve a session token.
VBA auto generated the python code which was executed with the shell function.
In this particular app, only with the session token, could the application make XMLHTTP requests to Betfair.
If you are interested, the attached video was used to help my client set up an Betfair application key which also needed to be included in the auto login process.
In this way, Excel VBA capabilities can be leveraged with other open source code, python and OpenSSL in this example to build applications.