Hey all,

Was wondering how, if at all, you could use an xml feed to update prices into an excel spreadsheet. Is it possible? I have the xml feed data but am not sure how to go about it, you have to use macros in excel i think. Is this correct?
Any help would be more than cool....

Thanks.

__________________
I like Bing Lee.

Uhhhh. What is xml feed?

Must be the stuff they feed the b...y nags I'm betting on!?

very interested to find that out as well as google turns up diddly squat

davez!
I was just jesting, XML stands for Extensible Markup Language (XML).
It is just an other file format to transmit info. Nothing special.
Still think the horses I'm betting on must be high on the stuff?

no worries marcus, i spend an unhealthy amount of time these days using excel, both for the punt & the my other "work", so when i read a line like "xml feed" i get a strange sort of fuzzy feeling allover, which i guess relates to me looking for another way to make my life a bit easier, data entry wise that is.

davez
If you are using recent versions (not Excel97) of Excel you will find an option under the Data tab, Import external data/Import data and on the window "Select data source" you will find "Files of type" option, there is an option to select XML files. Of course you would have to know the location of the file.
Cheers

Hi Marcus,
How would you use that function to import an xml feed from an online bookies, to update prices, given that they freely provide the feed and associated data references?

__________________
I like Bing Lee.

If you follow what I wrote above you should be able to get it. In the field "File name" just paste in the site address.
If you have a problem, I can try it for you.
Give me the site address in plane language just the middle bit, no http or htm at the end, because as I gether, management will blank it out.

Thanks Marcus, that did the trick.

__________________
I like Bing Lee.