I feel like every few months I get the simplest of errors that my equally simple mind does not solve despite its best efforts.

Here is one such thing.

For one of my projects (handling confidential data), I have been given a set of 500+ XML files, all with similar information. each XML has 1000 rows of data. They are called 1.xml, 2.xml, etc. I need to get these data into MYSQL. I dont know why they had to split it into 500 files and all that, I have to just " shut up and load them into the DB".

Please Login or Register  to view this content.

Now, If I dont supress errors, nearly 1/3rd of the files err out with the following error:
Please Login or Register  to view this content.
The xml files are all in UTF-8 ( the header in each says 
Please Login or Register  to view this content.
).

Nothing online talks about reading XMLs in UTF8 using vba.

I just have to do this ONCE for all the file to get one, clean excel sheet.
Sigh.