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