PDA

View Full Version : Solved: Create a web service call from Excel 2007



scott56
03-01-2012, 06:08 PM
Hi,

I am about to start the development of an Excel based solution that will retrieve information from a web service.

I have been able to find alot of reference information on integrating web service calls with Excel 2003 using a web service toolkit for XP.

But I also see that this is no longer supported or the SOAP protocol.

Can anyone provide advice or links to information on developing the code required to communicate with a web service from Excel 2007.

Regards
Scott

Kenneth Hobs
03-02-2012, 06:47 AM
I don't have the kit or the web site to test so I can't help with that. For Soap examples see:

http://www.vbaexpress.com/forum/showthread.php?p=252560
http://www.vbaexpress.com/forum/showthread.php?t=34354

scott56
03-02-2012, 01:00 PM
Thanks for that Kenneth,
Exactly what I needed