Consume XML from a Web Service

E

elliott

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.
 
C

challa prabhu

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

Excel VBA as a web service 0
How do I consume web services in Excel 2007? 0
Cannot Import XML Spreadsheet 2003 with XML Data Source 0
how to setup web service reference in excel 2007 vba? 0
MS InfoPath cannot consume a web service developed using JEE 2
Excel calling WCF service 0
Need to stop automatic column re-sizing when importing XML data 0
remove macros, ActiveX controls, XML expansion pack info, or web c 1

Top