Web Service Query Data Into a Cell

[becky78]

Hello!

I have figured out how to do this with Google Spreadsheets quite easily, but ran into some inherent limitations with Google Spreadsheets, so I am moving back to trying this in Excel.

I would like to make a query to a web service API, get back some XML and then pull out and populate a cell with an amount from that XML. I understand how to import XML data into Excel, however, I need to do a separate query for hundreds of lines, not just getting data from a single query. So I'd like to create a function that works like Googles ImportXML("URL","XPATH"); At this point, I am assuming that VBA is the only way.. but I'm not really sure how to go about it. If anyone could point me to an example it would help tremendously.