+ Reply to Thread
Results 1 to 2 of 2

need macro to consolidate data from .xml files.

  1. 09-26-2012, 02:54 AM #1
    sekharyadav
    sekharyadav is offline
    Registered User
    Join Date
    05-20-2010
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    24

    need macro to consolidate data from .xml files.

    Could any one please help to consolidate data from different (5000 +) xml files with below fields

    <RequestDateTime>
    <Db2DocId>
    <FnCEDocId>
    <ErrorMessage>
    <LoginId>

    Sample file attached.

    Thanks,
    Sekhar.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-27-2012, 11:03 AM #2
    Tinbendr
    Tinbendr is offline
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: need macro to consolidate data from .xml files.

    I only have a suggestion.

    You should be able to merge all the files together using the method from this page. Then rename the extension to a xml and open with Excel. I tried that with your sample file and it pulled it right in.

    Good luck!
    David
    (*) Reputation points appreciated.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1