Hi,

I have an XMl file like show below:

Please Login or Register  to view this content.
Can anyone please tell me how to extract the tags and its attributes?

basically the task is to check the tag name, if the tag name is like TRANFORMATION, then read the attribute TYPE ="Lookup Procedure", since the value of TYPE is "Lookup Procedure" so we should check if the NAME is starting with LKP_

I am new to VBA, so any help would be great for me.

Thanks,
Gooutham