Log on to BPC/EPM using Excel VBA

I am trying to log on to BPC using VBA in Excel. I found a post on this website that gives code that should work, but I get the error 'Run-time error 424: Object required'. I may be omitting a reference, but if so, I don't know which one.

The line of code that causes a problem is:
client.Connect "BPC Planning Prod", MyUserName, MyPassWord

Any help would be appreciated.