I have very strange requirement from client, want to access Java Web service in excel without MSSoap toolkit. I found MSSOAPLib (Microsoft Soap Type Library). The web service has complex DTD with attributes.

Firstly is it possible or not to access using MSSOAPLib? If so then i'm getting below error

No Deserializer found to deserialize a 'urn:GPDFQV:SOAPSDK1:CallerInfo' using encoding style 'http://schemas.xmlsoap.org/soap/encoding/'

Appreciate urgent help.. If required i can send code and web service DTD for reference.