@B15K3,This error came in a couple of cases over time. It sounds as if the the VBA code calls a method of the API with parameters with a wrong set pf parameters. This is funny as IB has not changed the method calls for literally decades. And they will not because it would break all software connected to it.
I have honestly no clue what causes it and what is going on, I cannot reproduce it. Some users have success with reinstalling the API in C:\, some with switching to/from 64bit version. One with upgrading to Office365. Sorry I cannot be of more help.