Hello All,

So, the algorithm of what I'm trying to do is the following:

1) IN directory C:\folder, for any .doc OR .xls document found
2) IF string "Objective" AND ( "X" OR "Y" OR "Z") are found
3) THEN SAVE name of the file in either a txt OR xls file
4) AND tell me which variables were found in what file (variables={ X, Y, Z})


I currently have a vba code for this algorithm:

IF either one of variables X OR Y OR Z IS found, tell me how many times.

Please Login or Register  to view this content.
But that is as far as I have been able to go.

Thanks for the help,
anrivel