Impending inventory software implementation requires extracting 25-40 data fields from 1000+ legacy XLS files.
Unfortunately, Excel was used a “product” sheet generator with one sheet per file, laid out to print as 3-hole punch inventory sheet.
Fortunately, each file/sheet has a consistent layout; i.e., the product ‘style’ number is always in B2.
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.
TIA