Consume XML from a Web Service

G

Guest

Can anyone tell me how to consume XML data in Excel from a Web Service? In
particular financial data on stocks. We have several web services that
return data in xml format but for the life of me I can't figure out (easily)
how to consume the feed?

Using Excel 2007.

Thanks in advance for your help.
 
G

Guest

Hi,

Note XML features, except for saving files in the XML Spreadsheet format,
are available only in Microsoft Office Professional Edition 2003 and
Microsoft Office Excel 2003.


Click Refresh XML Data on the XML toolbar to import the latest data from
the data source.

Challa Prabhu
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I consume a web service that doesn't have a WSDL? 1
consume web service from winform app 1
Running web service on non-standard port 4
consume web service via httpwebrequest 2
How to consume a Web Service made with ASP 3 from asp.net 1
Can XML Schema Be Refreshed Along with XML Data? 2
Import Multiple XML Files into Excel 3
remove macros, ActiveX controls, XML expansion pack info, or web c 1

Top