Here is the goal to archive all files and folders greater than 5 years, I have got the list from using some code that basically list all files folders and attributes (can post if anyone is interested...
what i have done now is created a list of anything that is older than 5 years since it has been modified.
the only thing is the list had the whole file path so i wanted to shorten that down:
e.g had L:\Administration\Reports\2001-2002 - Reports\End December 2000 Monthly Report.xls
and basically split that over some rows using data -> text to columns -> then delimited with the "\" and removed the first part "L:\"
now what i want to do is move the files to and archive folder, I was thinking along the line of something that checks the cell if it contains not "." then create the folder in the archive folder if the folder exists then move right to the next cell, same logic check if there is a "."... if there is a "." then move that file into the previously created folder.
Is anyone following this??? I am having one of those days that never end
what i have done now is created a list of anything that is older than 5 years since it has been modified.
the only thing is the list had the whole file path so i wanted to shorten that down:
e.g had L:\Administration\Reports\2001-2002 - Reports\End December 2000 Monthly Report.xls
and basically split that over some rows using data -> text to columns -> then delimited with the "\" and removed the first part "L:\"
now what i want to do is move the files to and archive folder, I was thinking along the line of something that checks the cell if it contains not "." then create the folder in the archive folder if the folder exists then move right to the next cell, same logic check if there is a "."... if there is a "." then move that file into the previously created folder.
Is anyone following this??? I am having one of those days that never end