Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello All,
I have a serious problem which I will try to explain as clear as possible. I am trying to archive old folders based on the date its files we're modified. There are a couple conditions though: 1. I want to move the entire path including the files to a new directory. 2. If there is one or more files in any sub-folder that was modified after 12/31/05 then do not move anything. So in laments terms: If all FILES in the folder we're modified before 12/31/05 then move from S:\AS BUILTS\ *PATH* to S:\OLD PROJECTS\ *PATH* Otherwise do nothing. (FYI. Date Modified of the folders themselves is disregarded) I have a list already created from the windows search of all files modified on or before 12/31/05 in columns as Name / In Folder / Size / Type / Modified A301AV415.zip S:\AS BUILTS\AQR\12443\Arch 1,301 KB WinRAR ZIP archive 4/19/04 8:51 AM I can create a list of all the files if that helps. Is this possible with Excel? Thanks So Much - Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date modified changes when file not saved | Excel Discussion (Misc queries) | |||
insert the date the file was last modified | Excel Discussion (Misc queries) | |||
Last modified date of a linked file | Excel Discussion (Misc queries) | |||
date file modified | Excel Discussion (Misc queries) | |||
insert the date the file was last modified | Excel Discussion (Misc queries) |