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
Sub ImportXMLtoList() Dim strTargetFile As String Application.DisplayAlerts = False strTargetFile = "C:\BookData.xml" Workbooks.OpenXML Filename:=strTargetFile, LoadOption:=xlXmlLoadImportToList Application.DisplayAlerts = True End Sub
But when i run above code i am getting error something related to "Schema"
Looking for help guys.
Thanks in Advance