I have a problem: I have an application which uses SOAP to send messages and WDDX to serialize complex objects. My client application is written in VBA. Unfortunately, the WDDX project seems to be abandoned, as COM libraries, so I'm looking for another xml-object mapping as an alternative for WDDX. Have you got any idea of what I might use?
Are you planning to rewrite this application or just the communication component (because even that can place constaints on the solution)? It should be possible to develop a .NET component that uses up-to-date communications protocols and technology and then make it available through a COM Callable Wrapper (CCW) to the legacy VB(A).
Unfortunately, I can't install a .NET component, because I also have the client upgrading problem: if I decide to add new SOAP methods, my .NET stub should be upgraded automatically. Moreover, I should install the .NET framework on every client (1000+). Finally, my VBA macro is able to auto upgrade, so the upgrade does not require a manual intervention.