I have a directory with approx 800 xls files
i want to look if a xls file has a certain number in it.for example i want to search for number 6, when it is found in different files(for example in 300 files) i want a list in a new workbook in which workbook they stand, is this possible without opening each file .
Greetings, Herman
i want to look if a xls file has a certain number in it.for example i want to search for number 6, when it is found in different files(for example in 300 files) i want a list in a new workbook in which workbook they stand, is this possible without opening each file .
Greetings, Herman