Import multiple files from same directory

I have a folder that contains multiple csv files, like so..

f-100713 XXX.csv
f-100713 XXX.csv
f-100713 XXX.csv
f-100713 XXX.csv
f-100713 XXX.csv
f-100713 XXX.csv
f-100713 XXX.csv
f-110713 XXX.csv
f-110713 XXX.csv
f-110713 XXX.csv
f-110713 XXX.csv
f-110713 XXX.csv
f-110713 XXX.csv
f-110713 XXX.csv
f-110713 XXX.csv
f-110713 XXX.csv
f-110713 XXX.csv
f-110713 XXX.csv
f-110713 XXX.csv
f-110713 XXX.csv
f-120713 XXX.csv
f-120713 XXX.csv
f-120713 XXX.csv
f-120713 XXX.csv
f-120713 XXX.csv
f-120713 XXX.csv
f-120713 XXX.csv
f-120713 XXX.csv
f-120713 XXX.csv
f-120713 XXX.csv
f-120713 XXX.csv
f-120713 XXX.csv
f-120713 XXX.csv
f-120713 XXX.csv
r-100713 XXX.csv
r-100713 XXX.csv
r-100713 XXX.csv
r-100713 XXX.csv
r-100713 XXX.csv
r-100713 XXX.csv
r-100713 XXX.csv
r-110713 XXX.csv
r-110713 XXX.csv
r-110713 XXX.csv
r-110713 XXX.csv
r-110713 XXX.csv
r-110713 XXX.csv
r-110713 XXX.csv
r-110713 XXX.csv
r-110713 XXX.csv
r-110713 XXX.csv
r-110713 XXX.csv
r-110713 XXX.csv
r-110713 XXX.csv
r-120713 XXX.csv
r-120713 XXX.csv
r-120713 XXX.csv
r-120713 XXX.csv
r-120713 XXX.csv
r-120713 XXX.csv
r-120713 XXX.csv
r-120713 XXX.csv
r-120713 XXX.csv
r-120713 XXX.csv
r-120713 XXX.csv
r-120713 XXX.csv
r-120713 XXX.csv
r-120713 XXX.csv


I would like to import all files into a workbook based on 2 criteria ( r or f) and the the number that follows.
So that (for example) all the files that contain f-100713 are saved in the same workbook.
...and all the files that contain r-100713 are saved in the same workbook.

In my example of files I would end up with 6 workbooks f-100713, f-110713, f-120713, r-100713, r-110713, r-120713.
The "XXX" part of the filename can be almost anything so I presume I would need some kind of wildcard.
I am unsure how I can achieve this.

Any assistance appreciated.

Thanks!

Can anyone assist with how to use wildcards in selecting files?

KH,

I tried your code and I kept getting "no files found".

I use this code to import all the files into the same workbook.
I have not been able to manipulate it so that it will split the files into separate workbooks on my criteria.

As you can see the code creates a list of all the files in the directory. I have tried setting a variable for x (the first 2 numbers) then looping x with no success.

Note: the file names are all f/r-100713 XXX, the XXX bit is NOT always 3 characters. The '100713' part is actually the date, I could change the file names so that the date part is a number i.e f-41465 XXX. I can do this when I create the files so it is not a big issue.

If you [or anyone else] have any suggestions about how I could manipulate my code that would be great.
Thanks for your assistance.

Please Login or Register  to view this content.

Attached sample of csv files

csv sample

Thanks very much KH, your code does the job nicely and will save me many hours of manually doing the job.