+ Reply to Thread
Results 1 to 5 of 5

XML file conversion to Excel file using macro

  1. #1
    Registered User
    Join Date
    08-04-2014
    Location
    Mysore
    MS-Off Ver
    2007
    Posts
    35

    Question XML file conversion to Excel file using macro

    Hi,

    I want to know how to convert XML file into excel.
    I know using wizard method, if i use that table format alignment will be differing.
    i required data should be in regular format.
    i enclosed a file with flow.

    xml file is not uploading so i written script in one sheet..
    please suggest me how to ensure this using macro functions.

    Thank you,
    Thara
    Attached Files Attached Files

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,384

    Re: XML file conversion to Excel file using macro

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-04-2014
    Location
    Mysore
    MS-Off Ver
    2007
    Posts
    35

    Re: XML file conversion to Excel file using macro

    Hi,

    Thank you.. for providing solution for xml to excel
    if we want to convert excel to xml i.e vis versa means..
    Last edited by thara.p24; 08-16-2014 at 07:00 AM.

  4. #4
    Registered User
    Join Date
    08-04-2014
    Location
    Mysore
    MS-Off Ver
    2007
    Posts
    35

    Question Re: XML file conversion to Excel file using macro

    Hi,
    Along with the above query, I want one more clarification in which if we exported Xml file into excel file, i want to select only required fields/columns into a separate sheet, how this can be resolve...
    I enclosed only excel file. please refer.

    Thank you.
    Attached Files Attached Files

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,384

    Re: XML file conversion to Excel file using macro

    Search the first row for columns you want and copy to another sheet.
    Because you stipped the xml information when converting to normal excel range you will need to write the xml file with code.

    Perhaps you should not convert the imported xml if you want to save it as well.

+ 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. Excel File Conversion
    By Cincy in forum Excel General
    Replies: 5
    Last Post: 07-29-2013, 05:37 AM
  2. Looping a macro over all files in a folder for a file conversion
    By hippie_dream in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-10-2011, 12:11 PM
  3. Excel file conversion
    By RCPhinney in forum Excel General
    Replies: 1
    Last Post: 08-16-2006, 06:50 PM
  4. Excel file conversion?
    By Bobby P. in forum Excel General
    Replies: 0
    Last Post: 07-31-2006, 10:18 AM
  5. Excel File Conversion
    By Turquoise_dax in forum Excel General
    Replies: 0
    Last Post: 06-21-2006, 09:59 AM

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