VBA Code to Move Excel files from one folder to another

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

Yes, the accounts are currenly listed in the following spreadsheet located at:
C:\Documents and Settings\mhamid\Desktop\Wave 2 Accts\Waive2PIAccounts.xls

There is only one tab in that sheet and the account numbers are listed in column A. There is no other data in column A that would cause any issue.
The only other data in the sheet is in column B where we have the people's name who are responsible for each aprticualr account. That can be ignored completely as it will not be relevant to the VBA code.

Yes, we can mark the account numbers that were succesfully found and moved or vice-versa in column C, if possible.


Thank you,
Miriam

I would prefer the macro to be run from a separete workbook where people can just copy their accounts and run the macro.

The accounts are currenly listed from cell A2 in the Waive2PIAccounts.xls workbook.


Thank you

There are other files and subfolder within the account # folder. Everything else is to be ignored except for the two files I mentioned.
I only need the files specified files moved.


Thank you

The code works great, but I actually needed it to make a copy of both the excel and pdf files to the Audits folder. Is there a way to correct the code?

Thank you

This worked perfectly.

Is it possible you can explain how the code worked? For intance, what part of the code made it possible not to duplicate anything that was previously copied?

Thank you,
~Miriam