kscott
02-28-2005, 09:57 AM
Hello everyone,
I am very much a newbie to VBA. I am a Java developer, and we want to be able to write VBA macros for clients to be able to access our web services through their excel in an oblique fashion. This would be a neat trick, unforunately I can't seem to make it work for my services with any type of complex type. Every time I run them, then I get an error "unspecified client error". I've tried a number of things including editing the wsdl to set all the min and maxOccurs to 1. This didn't seem to affect it. I have tried a service on the exact same system, using the same set-up (J2EE) and it works ok, but it only sends and recieves strings. This error is not really helpful, I've looked at a lot of VBA articles and tutorials, so I'm hoping some VBA-Jedi can give me an idea of something to look at, that might be causing this problem.
Thanks,
Kevin
I am very much a newbie to VBA. I am a Java developer, and we want to be able to write VBA macros for clients to be able to access our web services through their excel in an oblique fashion. This would be a neat trick, unforunately I can't seem to make it work for my services with any type of complex type. Every time I run them, then I get an error "unspecified client error". I've tried a number of things including editing the wsdl to set all the min and maxOccurs to 1. This didn't seem to affect it. I have tried a service on the exact same system, using the same set-up (J2EE) and it works ok, but it only sends and recieves strings. This error is not really helpful, I've looked at a lot of VBA articles and tutorials, so I'm hoping some VBA-Jedi can give me an idea of something to look at, that might be causing this problem.
Thanks,
Kevin