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.
But that is as far as I have been able to go.
Thanks for the help,
anrivel
Bookmarks