retreive xml data not taking exact column name

[sarat47]

Hi,

I am currently using the below macro to import multiple XML file into single excel file and it is successful.

The problem is that the macro is not able to display correct column name. Is there any option to visualize it.

Also if more than 100 XML file are there, is there any possibility to make sure that all the xml file are imported without missing any file.

I copy the xml file to notepad for reference.

For the column P, the name displayed as "/PORR_IN049016UV/controlActProcess/@classCode" in stead of "class code". I understand the column html code is wrapped as a sub class of another class but is there a possibility to visualize only column name without showing path.

Please Login or Register  to view this content.

[mjr veverka]

Incorrect structure of 'xml' file:
1. In excel: error -1072896682, Invalid value at the top level of the document, Row 1, Column 39, File offset 38
2. In XML Notepad: Data at the main level is invalid, Row 3, Position 1