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