0 Replies - 1932 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
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

Is This A Good Question/Topic? 0
  • +

Page 1 of 1