Import XML into Excel

Can anyone guide me to as how I can import the BOM that wascreated in SW, exported through the API as XML. Now if I try andopen that using excel, it does not come in correctly. Can someoneadvise?


Thanks,

RodneySolidworksApi macros