0 Replies - 2981 Views - Last Post: 24 August 2012 - 06:43 AM Rate Topic: -----

#1 Manukrrish  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 24-August 12

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

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

Is This A Good Question/Topic? 0
  • +

Page 1 of 1