+ Reply to Thread
Results 1 to 1 of 1

Problems importing, saving and modifying XML

  1. #1
    Registered User
    Join Date
    06-06-2016
    Location
    Brisbane, Australia
    MS-Off Ver
    2013
    Posts
    1

    Problems importing, saving and modifying XML

    Hi folks,

    I have some XML I need to read, modify, and save for a model railway configuration application.

    Reading in the XML and letting Excel create the map seems fine.

    If I could programmatically create a table to each of the three elements in the xml - MergModules, UserEvents, and UserNodes would make processing this easier in my mind but I'm not sure how to do that.

    Excel refuses to export the xml I get a message "Cannot save or export XML data. The XML maps in this workbook are not exportable."

    Trying to figure out how to resolve, or even if resolution is possible, has just led to a stream of incomprehensible documents around the web.

    I'm trying to do the work in Excel rather than a programming language as Excel is great for the actual configuration piece visually, is familiar to many users, is already installed for many users, and does not rely on the user installing something new on their machine.

    I uploaded a sample file but the forum won't let me put a link in as this is my first post. Modifying_XML.xlsx

    I will contact the admins to see if they will put the link in.

    The map can be seen using Developer->Source


    Regards and Thanks,
    Greg
    Attached Files Attached Files
    Last edited by grog_polymer; 01-27-2021 at 11:08 PM. Reason: problem with title

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problems with importing data
    By gtg430i in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2017, 09:14 AM
  2. Importing from another worksheet problems.
    By excel-medic in forum Excel General
    Replies: 8
    Last Post: 09-29-2016, 04:32 AM
  3. Problems with importing XML files
    By chephy in forum Excel General
    Replies: 3
    Last Post: 01-17-2010, 01:28 PM
  4. Column Problems When Importing
    By Wrkoutguy08 in forum Excel General
    Replies: 1
    Last Post: 03-11-2008, 07:16 PM
  5. importing data problems
    By jaimetimbrell in forum Excel General
    Replies: 4
    Last Post: 06-17-2007, 09:34 AM
  6. Problems with Importing a File
    By Mystrunner in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2006, 08:50 PM
  7. Problems importing a CSV-file
    By ApPojken in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-16-2006, 07:20 AM

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