Loop through XML file and get nodes

I've got i working by looping through the XML and if the the parameter i was looking for didnt occur, then it will just resume next.

I'll leave the code here, if someone happens to have the same problem.

Please Login or Register  to view this content.

@CasperVest ;

Using "On Error Resume Next" statement is not good actually, because it suppresses all kinds of errors if exists and you cannot rely on the results you get. Also, you have to close the unchecking error procedure by placing a "On Error GoTo 0" statement immediately after when you are satisfied with unchecking the errors.

Having said this, you can try the code below where instead of "On Error Resume Next - On Error GoTo 0" statements, the existence of XML nodes are checked....

Note that, the related XML should be placed with Excel file in the same folder.

Please Login or Register  to view this content.

Hi Haluk, thank you for taking a look at the code, i see your point for not using "on error". Your suggestion is definitely better, so i will go with that.

Thank you so much for the answer!

Sorry about the edit of the post, did not see that it changed the whole post.