map xml node from parent node

[Arafat]

Hi,

I'm trying to write a macro to map the xml folder elements on different worksheets, But the problem is i have to map individual columns against the xml schema elements, I need a macro that could check the worksheet name and map the particular node to that sheet at one go... please help .

Thanks
​