Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to extract only file name from folder path string in Excel? | Excel Worksheet Functions | |||
in which folder can you save a .CSV file? | Excel Discussion (Misc queries) | |||
How to create a list of file names within a folder in Microsoft Ex | Excel Discussion (Misc queries) | |||
Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
extract info from XP File System | Excel Programming |