Hi,

I have an XMl file like show below:

<TRANSFORMATION DESCRIPTION ="Created by: NESS&#xD;&#xA;Created Date:- 07-DEC-2011&#xD;&#xA;Description:- Lookup on  GID_INTL3PTY_SRC_FILE_RLTN SFR, GID_INTL3PTY_SRC_SYSTEM SRC, GID_INTL3PTY_STATUS STTS t to get File_id,Book_id and Src_sys_Id using the FIle name as parameter" NAME ="LKP_GID_INTL_3PTY_SRC_FILE_RLTN" OBJECTVERSION ="1" REUSABLE ="YES" TYPE ="Lookup Procedure" VERSIONNUMBER ="1">
        <TRANSFORMFIELD DATATYPE ="decimal" DEFAULTVALUE ="" DESCRIPTION ="" NAME ="FILE_ID" PICTURETEXT ="" PORTTYPE ="LOOKUP/OUTPUT" PRECISION ="15" SCALE ="0"/>
<TRANSFORMATION/>
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