XML and Excel macros?

[IowaBearcat]

New to the board, but I have a question as to whether or not this is even possible.

I have an XML file that is randomy generated from a program that is needed to decipher column headers in Excel. For example, the XML file says:

AS_00 = Address
AS_01 = Name
AS_02 = Birthplace

The data in excel is full columns of information with column headers of "AS_00", "AS_01", etc.

So naturally, its easier to match them up, one at a time, but the problem is this:

Each XML file is randomly generated for some terrible reason and while one XML file looks like above, the next one could look like this:

AS_00 = Name
AS_01 = Birthplace
AS_02 = Address

So all of my XML files are different, thus each Excel file is different. They all contain the same information, but both are generated in a differnet order/sequence.

So the big question and point (sorry for the long explaination), is:

Is there is any way to program in Excel to read an XML file and replace headers? If I can get everything into Excel, it's easier to manage columns than it is to manually change and match-up each column header.

Thanks in advance.