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!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by 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...- techadmin2012
- Post #4
- Forum: VBScript
-
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...- techadmin2012
- Post #3
- Forum: VBScript
-
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?- techadmin2012
- Thread
- Replies: 3
- Forum: VBScript
