Codes for looping thru all file when matches found

[cokillerliu]

Need to loop thru all files in a folder, then move data to a master spreadsheet when criteria matches.

It is not working as expected. But i can't figure out way. I am guessing it has something to do with where " Set WBD = Workbooks.Open(Filename:=thisfile) " needs to be.

Thanks.

Please Login or Register  to view this content.

[AlphaFrog]

Replace this...

Please Login or Register  to view this content.

With this...

Please Login or Register  to view this content.

Otherwise, can you better explain what; "It is not working as expected." means? Both the "not working" and the "expected" parts.