Hi I am working on some stuff where i need to Import the data present in XML file to excel sheet.
i wrote below code for it
Dim strTargetFile As String
Application.DisplayAlerts = False
strTargetFile = "C:\BookData.xml"
Workbooks.OpenXML Filename:=strTargetFile, LoadOption:=xlXmlLoadImportToList
Application.DisplayAlerts = True
But when i run above code i am getting error something related to "Schema"
Looking for help guys.
Thanks in Advance