XML-Schema - new row in imported schema



I create a xml-schema with the code from this site.



Sub Create_XSD2()


Dim StrMyXml As String, MyMap As XmlMap
Dim StrMySchema As String
' Book.xml is the file created in section one of this topic.
StrMyXml = "C:\BookData.xml"

' Turn off async loading.
Application.DisplayAlerts = False
' Add the string to the XmlMaps collection.
Set MyMap = ThisWorkbook.XmlMaps.Add(StrMyXml)
Application.DisplayAlerts = True

' Create an empty file and output the schema.
StrMySchema = ThisWorkbook.XmlMaps(1).Schemas(1).XML
Open "C:\BookData2.xsd" For Output As #1
Print #1, StrMySchema
Close #1
End Sub


After I import the data from the xml file everything is placed in one row. How can i change that? Thanks, Laurenz


No comments:

Post a Comment