Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. techadmin2012

    Use VB to create Excel file from multiple XML files

    I found a solution and it is pretty simple. Simply create a macro: Sub xmlImport() fld = "c:\cortex\inbound\" i = 2 found = False fil = Dir(fld & "*.xml") Do While (fil <> "") found = False Location = fld & fil ActiveWorkbook.xmlImport URL:=Location...
  2. techadmin2012

    Use VB to create Excel file from multiple XML files

    Thanks for the help. This partially works. Here is what I have in each of my XML files. I need create a spreadsheet with headings for Invoice Response Number Original Invoince Number Status Invoice Response reason Comments. I need each column to then be populated from the data in each of these...
  3. techadmin2012

    Use VB to create Excel file from multiple XML files

    I have over 800 XML files in a directory. I need to read each file, extract 2 pieces of data from each and populate an excel spread sheet. One column is the first piece of data and column 2 is the second piece of data. Each XML file is only one line long. Can anyone help me with this?

Part and Inventory Search

Back
Top