String parsing to get name of csv file

I have an Access database that links .csv files (comma delimited files) such as Perfect.csv to my database from my computer. I want to string parse by the specific name of the original file from the Backup_Dest to the Copy_Dest.

The name of the Backup file is 20130715_15_44_Perfect.csv
Another name of a Backup file could be 20130714_17_16_Perfect.csv

The name of the Copy file will be Perfect.csv

There must be a pattern as to why this Backup file is named the way it is...I know that the first digits are 2013 (year) 07 (month) 14 (day).

(1) I don't know what the digits mean after that. I need to answer that question first before, I can predict what the rest of the files will look like when I string parse.
(2) I want this code to string parse and copy the files from the Backup folder to Copy files folder in a loop by CurrentDate.
For example if the CurrentDate = 07/15/2013 it needs to pull the file with this date in the .csv file name.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

csvFiles.PNG

Here is a picture of what the csv files look like.

20130102-09-17-Perfect.csv

I think another solution would be to hard code these csv file names, example "20130102-09-17-" & stringFileName

Please help me think of a solution

The created time could be the hours and minutes of the csv string. But the time it was recorded is not the same as the string name. So that's not the solution unfortunately.

I wrote some code that makes the program work. Ahah!