<img src=/S/crybaby.gif border=0 alt=crybaby width=15 height=15> Impending inventory software implementation requires extracting 25-40 data fields from 1000+ legacy XLS files. <img src=/S/puke.gif border=0 alt=puke width=60 height=15>
<img src=/S/sad.gif border=0 alt=sad width=15 height=15> Unfortunately, Excel was used a "product" sheet generator with one sheet per file, laid out to print as 3-hole punch inventory sheet.
<img src=/S/smile.gif border=0 alt=smile width=15 height=15> Fortunately, each file/sheet has a consistent layout; i.e., the product 'style' number is always in B2.
<img src=/S/help.gif border=0 alt=help width=23 height=15> Looking for quick and dirty VBA module or code fragment that would cycle through all XLS files in a target directory and copy target cells into a new consolidated file/sheet.
This is a one-time event so it doesn't have to be pretty.
Didn't see anything close in the archives.
The sample file has been changed to protect the innocent.
Any and all comments or suggestions greatly appreciated.