Page 2 of 2 FirstFirst 12
Results 16 to 21 of 21
  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 08:03.

  6. #21
    New Lounger
    Join Date
    Sep 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Variation on your theme!

    Quote Originally Posted by Maudibe View Post
    zmagic,

    Sorry, I misunderstood. I thought you wanted to read the xml file line by line onto a spreadsheet which the initial code does. You want the file imported not to view the XML coding but to display the file in human readable form. I now understand your intent.

    By not having a sample file, this is a bit difficult to determine the schema. However, I took a stab at it and this works well with XML files I have. Give it a go.
    Hi Maudibe - I have a similar situation where I need to extract xml tags from some drawing files. There is no "map" supplied. If I open them individually I get a lot of lines and rows - I am new to xml tags so not sure if this is normal!
    I can however trim the xml tags required right down to approx. 10 tags.

    You mention that you can extract particular tags out in the VBA - how - any clue would be appreciated.

    Thanks in advance.
    Andy

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
  •