ExcelBanter - Importing XML into Excel 2003 from a URL

SQL files have standard format while XML files very a lot. I would start by
saving the XML file on your PC and then look at the text with Notepad. You
can write a script that reads the text file and then extracts the data you
want. Later you can automat fully by geting the XML file from the internet.

XML files are hypertext ascii files.they would look like this

<textOne line of Text<end text

<text and <end Text are tags. In a XML file there will be header tags,
fiormat tags, and data tags. to extract the datq you need you'll have to
search the tags and only get the tags you need to complete your task.

the best way tosee how complicated the job would be is to look a the file
with NotePad or we you are looking the page with the internet explorer View
Source in the Page Menu.

"BigAndy" wrote:

I wondered if you could help me, I want to create a spreadsheet that
is updated vie a link to a standard web XML file. All the discussions
I've seen are regarding importing from a SQL server or a static file
but how would you import from (for example) www.example.com/file.xml
or file.aspx??