Searching multiple xlsx files to find all instances where cell K14<>0

Originally Posted by hudwink

I currently need to open each xls file to check cell K14=0 (only one worksheet in each file).

Paste the following macro to a new Module within a new Workbook.

This macro asks you for the files you want to check, which you can select multiple files from a single directory by holding down the CTRL or Shift button when selecting. If you have files in multiple directories, run this macro for each directory and it will just append the findings on the end.

Warning: This macro contains code which will close workbooks without saving changes. I have put a warning message within the code, but if you have anything else open, I suggest closing them first or risk losing any changes.

Please Login or Register  to view this content.

You sir, are a legend!

That does exactly what I need it to do, and has just saved me a half-day's work every month.

Thank you!