Unless they have made any massive changes to Excel VBA recently, you will need to write a COM wrapper for the Vault API functions you need
There's an old example for from 2017 that should get you started, but you'll definitely need to make changes to the login code, as that has changed a lot in recent years
