Hi,
  My requirement is to load the xml file into Excel to create the pivotting and analytical. It must be automated using VBA or some other way like macro recording.

  I have tried using xml,xpath and xml recordset and i have loaded the xml into excel. But when I'm trying to list out by Category wise or Country wise, it consumes huge time for to fetch the list of countries and Categories using Xpath preceding-sibling.

  I'm stuck.., Is there any other simplest way to do the requirement. Pls help me...

Thanks in Advance

viv

__________________
vivek