lookforsmt
Registered User.
- Local time
- Today, 14:50
- Joined
- Dec 26, 2011
- Messages
- 672
Hi! all i am looking to copy latest text files from one folder to another using VBA. The text file name consists of 4 parts:
The 1st part is the file type code and 3rd part is the date in format "YYMMDD"
Based on 1st and 3rd part i want to copy the files from the "OriginalFolder" to the "NewFolder"
I am looking in the forum for the vba code but nothing close
Can anyone help me with the code.
ICCSC01001026171215111900
Part1) ICCSC01
Part2) 001026
Part3) 171215
Part4) 111900
The 1st part is the file type code and 3rd part is the date in format "YYMMDD"
Based on 1st and 3rd part i want to copy the files from the "OriginalFolder" to the "NewFolder"
I am looking in the forum for the vba code but nothing close
Can anyone help me with the code.