How to Import the Xml file to Excel sheet using Excel macros,schema

Posted 24 August 2012 - 06:43 AM

Hi I am working on excel macros to Import the data present in Xml file to Excel sheet...I have written the below
code

Sub ImportXMLtoList()
Dim strTargetFile As String
Application.DisplayAlerts = False
strTargetFile = "C:\BookData.xml"
Workbooks.OpenXML Filename:=strTargetFile, LoadOption:=xlXmlLoadImportToList
Application.DisplayAlerts = True
End Sub

Its works fine when i use MS Excel 2007 and 2010 but not in MS Excel 2003.when i run this code in MS2003 its given an error message saying Schema not defined...Please help me on it to run this in MS Excel 2003
Thanks in Advance
ME