Another query regarding searching of files. This topic in VBA is not easy, at least to my standards.
This time, I want to search a folder which contains hundreds of data files. I want to search for those files based on the Last modified date/time. I want to search those files and copy them to a different destination and open them to copy a particular range of cells to another new work sheet for processing.
For example: I want to search for those files that were last saved in a particular month/week.
The code i need is to search and copy files at destination folder based on date range that I specify and open them. I hope that I can manage with the rest of the code.
I would like to input the date range at a particular cell in my worksheet which the code can access to perform the search.
Thanks in advance.