Gather data from multiple XML sheets?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AutoFilter and Sub-total 6
copy the data to all the columns 2
Help with search code 1
importing tabs/sheets only from the currently open files 1
How to combine amount in manys sheets into 1 summary sheets 2
HELPPPPP Please - Comparing Data 6
Index function in VBA - on Multiple cells 3
how to extract a sheet from another? 2

Back
Top