+ Reply to Thread
Results 1 to 1 of 1

XML & Excel 2010 - Why can't I export my changes?

Hybrid View

  1. #1
    Registered User
    Join Date
    07-09-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    XML & Excel 2010 - Why can't I export my changes?

    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!
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1