convert xml file into excel sheet

[ElvisSteel]

Hi,

I am reasonably experienced at excel and VBA, but I have a requirement whereby I need to read (convert) an xml file into excel, make some changes to the data and update the xml with the new data.

I have written some VBA to take an excel sheet and create the required xml. It's a bit basic but works OK, but I've no idea how to read the xml in.

I'm sure that Excel has various xml options but I don't have a clue where to start. Can anyone out there provide me with a very quick overview of how to work with xml in Excel (or point me towards a good reference)

Thanks

Steve

 

[Andrew Poulsom]

This may help you:

http://office.microsoft.com/en-us/excel/HA011019641033.aspx

 

[ElvisSteel]

Thanks Andrew