I have an Excel macro in which I run to import data from a XML file. Lately I've added some extra elements to the XML file and now it's not importing the data correctly.
In the XML file there are 3 sub elements for every main element:
The main element would have a time stamp within it and the other elements would have text.
When the 3 sub elements are blank the macro runs fine, but when one if the sub element has data within it the macro fails.
Try running the elements just with the main elements having a time stamp within them and then add some text to the sub elements and it shouldn't work.
Not sure what is happening.