Page 2 of 2 FirstFirst 12
Results 16 to 20 of 20
  1. #16
    New Lounger
    Join Date
    May 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts
    hi,

    I used the fle "XML Files_Revised.xlsm" but reflected the following error. "error run time -2147217376 (80041020) dtd not allowed..how can I fix it?

  2. #17
    New Lounger
    Join Date
    May 2014
    Posts
    1
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Many thanks for these fantastic macros, Maudible.

    I am using the "XML Files_Revised" macro and was wondering if it would be possible to auto-generate "labels" for each of the columns of data that are imported from all of the xml files. I will provide the following example, which I hope will clarify my request:

    The xml file contains a field and value of: <Price Value="36584" />

    The value 36584 nicely populates the respective row in a column, however could the "Price" be extracted from label to populate a header row in the worksheet?

    Hoping that makes sense.

  3. #18
    New Lounger
    Join Date
    Jul 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I am using the script, but having a problem.
    I am importing xml files that comes from different adobe forms
    most of the forms works perfect; but one of the forms puts a line with the "headers" first, and then repeats the data 3 times, over 3 lines. Like this

    "Name","date","country"
    Mike,12/07,UK
    Mike,12/07,UK
    Mike,12/07,UK
    "Name","date","country"
    George,07/04,FR
    George,07/04,FR
    George,07/04,FR

    On the other xml files there are no header displayed, wich is fine

  4. #19
    New Lounger
    Join Date
    Jul 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Importing multiple XML files into Excel

    Hi,
    Is it possible to import XML files with different headers? When the script finds a new column, it adds the column and the data for that column.

  5. #20
    New Lounger
    Join Date
    Jul 2014
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Paul Faoro Mwas View Post
    Hi,
    Is it possible to import XML files with different headers? When the script finds a new column, it adds the column and the data for that column.
    Yes, but when it does, it imports the file 3 times (1 line for the headers, and the 3 repeted lines with the data.

    I tried to list only file of the same format (from the same form) and the 3 repeat is only comming when importing data from 1 specific form, the other forms behave normally.
    I guess that it must be something in the forms (all created with Adobe life cycle)
    Last edited by crj9; 2014-07-29 at 07:03.

Page 2 of 2 FirstFirst 12

Posting Permissions

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