+ Reply to Thread
Results 1 to 3 of 3

Excel export multiple different tables to XML

  1. #1
    Registered User
    Join Date
    08-27-2020
    Location
    Tilburg, Netherlands
    MS-Off Ver
    2016
    Posts
    2

    Excel export multiple different tables to XML

    I have an excel (2016) document. On one sheet I have a table that I want to export to XML, no probleem. Now I ad an new sheet with a new and different table, that I also want to export to XML, this doesn't work. Is there a way to make this work?

    I using the menu 'Developer'. I added a XML-map. Made the table, with the XML-map. And then I export, with the button 'export' in the menu 'developer'
    Last edited by Susterki; 08-27-2020 at 04:04 AM.

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Excel export multiple different tables to XML

    Quote Originally Posted by Susterki View Post
    Now I ad an new sheet with a new and different table, that I also want to export to XML, this doesn't work. Is there a way to make this work?
    if the process for sheet 2 is the same for sheet 1, there should be no error. you said sheet 1's process works fine.

    Quote Originally Posted by Susterki View Post
    I using the menu 'Developer'. I added a XML-map. Made the table, with the XML-map. And then I export, with the button 'export' in the menu 'developer'
    what do you mean you added a XML-map? you restructured data to show it in the format of XML, you mean? XML orientation is nothing more than a tree of organized, hierarchial data, just like JSON and any other web service-oriented data format.

  3. #3
    Registered User
    Join Date
    08-27-2020
    Location
    Tilburg, Netherlands
    MS-Off Ver
    2016
    Posts
    2

    Re: Excel export multiple different tables to XML

    I have no idea why, but today it works with multiple sheets. Yesterday it didn't. Thanks

+ 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. [SOLVED] Macro to Export Word Tables to Excel
    By WesternGal in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-16-2018, 05:08 AM
  2. Export multiple pivot tables from Excel to Word
    By cokolwiek1987 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2017, 06:04 AM
  3. Macro to export MS Word tables to Excel
    By drakosss in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-19-2015, 08:43 AM
  4. Replies: 0
    Last Post: 02-01-2013, 06:17 AM
  5. How to control EXPORT of tables from Access to Excel?
    By toplisek in forum Excel General
    Replies: 0
    Last Post: 09-16-2009, 07:24 AM
  6. Export Access Tables to Excel Workbook
    By Tj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2005, 05:55 PM
  7. Replies: 2
    Last Post: 01-19-2005, 05:06 PM

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