Hello All,

I need some help/advise.

Is there a way to copy files from one folder to another using a VBA code?
I have a list of accounts where I will need to copy files from on folder to another. The thing is that there are over 50 accounts and I honestly don't feel like copying them one by one.

For instance, I have to copy a file for acct#1234567890. The excel files that I would have to copy are as follows:
1234567890_Top Sheet_2013.xls
1234567890_Rec Worksheet_2013.xls
The folder where the excel files are for that particular account would be:
K:\shared\InvestorBankRec\Reconciliations\1234567890
The folder where the excel files would have to be moved to would be:
K:\shared\InvestorBankRec\Audits\W2 07-2013

Then there is also a pdf file that will have to be moved from:
K:\shared\InvestorBankRec\Electronic Bank Statements\2013\07-2013\DDAUSA-111-1234567890-2013-07-31-39914276.pdf
The account number will always be after the 111- and before the -2013.
The folder where the pdf file would have to be moved to would be:
K:\shared\InvestorBankRec\Audits\W2 07-2013



Technically there are over 500 accounts where this would have to be done to and I was looking for a VBA code that would do that for us.

Would this be possible? I have no idea how to start the code, therefore I don't have a code written for this yet.
Please help if you can.

Thank you,
Miriam