Maybe someone can help me out with this vb script.
I'm trying to look in a folder and find files, which fall into certain categries and place them in the correct folders.
Default location of folder containing all the files.
U:\__Finance\_RRS_CHECK_TEMPLATE\READY\
File Formats.
Name_NUMBER-mmddyy.xls
What I'm trying to focus on is the "mmddyy" part of the name.
I want to take the "mmyy" and place every file with the same "mmyy" in a corresponding "mmyy" folder.
I was thinking about trying a For Next loop to do this, but any suggestions would be helpful.
Oh ya I want the folders to be automatically made if the "mmyy" exists.
I'm trying to look in a folder and find files, which fall into certain categries and place them in the correct folders.
Default location of folder containing all the files.
U:\__Finance\_RRS_CHECK_TEMPLATE\READY\
File Formats.
Name_NUMBER-mmddyy.xls
What I'm trying to focus on is the "mmddyy" part of the name.
I want to take the "mmyy" and place every file with the same "mmyy" in a corresponding "mmyy" folder.
I was thinking about trying a For Next loop to do this, but any suggestions would be helpful.
Oh ya I want the folders to be automatically made if the "mmyy" exists.