Hello All,
I'm new to the forum, so please bear with me.
I have the following attached XML file and created the following attached .XSD through excel. My question is why can't I export my changes? And what can I do so that I can modify my changes?
I mainly want to be able to change all of the Flag attributes from "TRUE" to "FALSE" and vice versa if needed. I used the following module to create the .xsd file. Is this wrong?
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:\BULK_CHANGES.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:\BULK_CHANGES.xsd" For Output As #1
Print #1, StrMySchema
Close #1
End Sub
I am able to import my data just fine and it looks great. But I can't really use it if I cant change my data. Please help!
Bookmarks