Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Gather data from multiple XML sheets?
I have a list of 5000 file names, all 5000 are full file names with paths,
and all 5000 are XML files. What I need is the field "Report" if it exists for each one, thats the only one I need. If I open an XML as a read only document (middle choice when opened from excel) the field "Report" does not fit on the sheet because there are more than 300 fields (most empty) Can anyone help me, with either a formula, or some code, that will let me get the information from this field for all 5000 files? I'm no expert with macros' and the macro I tried to record made no sense to me, and didn't look like it could be looped 5000 times changing to each document... Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Gather data from multiple XML sheets?
Post the code and I will clean it up. I never like the code that excel
produces either. But it is always a good place to start. "PaulW" wrote: I have a list of 5000 file names, all 5000 are full file names with paths, and all 5000 are XML files. What I need is the field "Report" if it exists for each one, thats the only one I need. If I open an XML as a read only document (middle choice when opened from excel) the field "Report" does not fit on the sheet because there are more than 300 fields (most empty) Can anyone help me, with either a formula, or some code, that will let me get the information from this field for all 5000 files? I'm no expert with macros' and the macro I tried to record made no sense to me, and didn't look like it could be looped 5000 times changing to each document... Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to update data from multiple sheets to one specific sheets | Excel Discussion (Misc queries) | |||
Gather data from multiple excel files into one master excel file | Excel Discussion (Misc queries) | |||
Gather data from multiple excel files in mutiple folders | Excel Programming | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to gather data from different excel workbooks into 1? | Excel Discussion (Misc queries) |