3 Replies Latest reply on Aug 10, 2004 3:15 PM by Christian Harms

    Excel 2002 calling JBoss.NET Web Service

    Christian Harms Newbie

      It's just so easy - at least up to doing a call without authentication and simple data types.

      Did anyone implement a web service interaction between Excel 2002 and JBoss including authentication? I know that there is something on this in the tutorials as well but are any pitfalls waiting for me not mentioned there?

      To share what I have learned so far on the topic:

      The WIKI on JBoss.NET provides an overview (tutorials) and an example which I build and deployed to JBoss 3.2.5.

      With JBossWS on JBoss 4 there is the J2EE compliant solution available. If I wouldn't want to go live with the service soon I'd go for that.

      "Microsoft Office XP Web Services Toolkit 2.0" provides an extension to the VBA environment to locate web services and to generate VBA classes to access them. It's accessible in the VBA Editors extra menu. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnxpwst2/html/odc_cmplxtypes.asp for details and be aware that there is also a newer Version called "Microsoft Office 2003 Web Services Toolkit" which I didn't use so far.
      See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odc_wst2003_ta/html/odc_wstknew.asp

      Using the toolkit it's a 2 minutes job to do the first call to the hello service.