H
Harapa
Appreciate any help that I can get to do this in excel.
I have a database of about 4000 files, when I update the database
daily some of files are not updated on a given day for variety of
reasons. I would like to know the names of all files that were not
updated on a given date. The structure of my data base is as follow
c:\DB\A (have all files begining with letter A)
c:\DB\B (have all files begining with letter B)
...... and so on untill the last folder as Z
c:\DB\Z (chave all files begining with letter Z)
I thought of two ways
First, to have a macro that will retrieve names of all files not
updated on the date supplied in the query
Second, to retrieve names and last saved date of all files and then
sort those in excel to find the one that has the last save date older
then in the query
I am sure there are bettr ways of doing this then above.
Appreciate your help and time.
I have a database of about 4000 files, when I update the database
daily some of files are not updated on a given day for variety of
reasons. I would like to know the names of all files that were not
updated on a given date. The structure of my data base is as follow
c:\DB\A (have all files begining with letter A)
c:\DB\B (have all files begining with letter B)
...... and so on untill the last folder as Z
c:\DB\Z (chave all files begining with letter Z)
I thought of two ways
First, to have a macro that will retrieve names of all files not
updated on the date supplied in the query
Second, to retrieve names and last saved date of all files and then
sort those in excel to find the one that has the last save date older
then in the query
I am sure there are bettr ways of doing this then above.
Appreciate your help and time.