Simi
New member
- Joined
- Feb 10, 2012
- Messages
- 190
- Reaction score
- 0
- Points
- 0
- Location
- Utah, USA
- Excel Version(s)
- Version 2002 Build 12527.20194
I am trying to cleanup some old files and want a macro to move my old files to a new folder.
I have a folder called Simi, that has sub folders in it a, b, c. The folder Simi also has files in it.
What I want is for a new folder named 2013 to be created in every folder that has files created in 2013, then move the files to the respective folders.
so in the folder Simi, we would end up with 4 folders, a, b, c, 2013.
in folder a would also be a 2013 folder.
in folder b there were no files created in 2013 so it gets skip'd
in folder c there is a 2013 folder.
I don't know if this is making sense or not.
Attached is the workbook with the code I am using.
In its current form, I am getting a duplicate 2013 folder. Simi/2013/2013
my problem is, I don't want it going into the subfolders of a, b, c. so I can't just call the consolidate sub again.
I have a folder called Simi, that has sub folders in it a, b, c. The folder Simi also has files in it.
What I want is for a new folder named 2013 to be created in every folder that has files created in 2013, then move the files to the respective folders.
so in the folder Simi, we would end up with 4 folders, a, b, c, 2013.
in folder a would also be a 2013 folder.
in folder b there were no files created in 2013 so it gets skip'd
in folder c there is a 2013 folder.
I don't know if this is making sense or not.
Attached is the workbook with the code I am using.
In its current form, I am getting a duplicate 2013 folder. Simi/2013/2013
my problem is, I don't want it going into the subfolders of a, b, c. so I can't just call the consolidate sub again.