Hi i having a problems trying to create some vba code to connect to a web service.

hopefully i will describe this as best i can.

I am using and have to develop this in Microsoft Excel 2003 using VB.

I have tried using the microsoft Web Services Toolkit but unfortunately it wont create the classes correctly so I have had to go down the route of hard coding it myself.

I am trying to connect to this web service

WebCrmApi Web Service

This is the class in my worksheet

Please Login or Register  to view this content.
This is code that runs when a button is clicked within the worksheet

Please Login or Register  to view this content.

so i am trying to pass the parameters to the function Auth.

at the moment all it currently does is throw this error

"Run Time Error 438 Object Error Doesnt Support This Property Or Method!"

Am i on the write lines in terms of utilising the web service to authenticate?
Anyone know why it would be throwing this error?
Please explain in simple terms as i am not that experienced in VB Code.

Thanks for any help.