Hi everyone,

new on the forum and getting started with vba:

I was wondering if someone could help me with the following >>

I have two Excel files stored on in different folders for example
test09Feb12.xls is stored in C:\Program Files\blp\data
report09Feb12.xls is stored in C:\Program Files\blb\data

Each morning when running the macro I want the macro to go to these folders and copy the content of latest file saved there, or simply the file with the name (with the date of the previous working day).
The worksheets I want to copy are called for example sheet1 in test09Feb12 and sheet 2 in report09Feb12.

In want the macro to copy these two sheets to a new Excel file called Summary09Feb12.xls And the name of this file is adapted according to the corresponding date (previous working date).

After having done this I would like to save the new created Excel file to lets say C:\Program Files\reporting

After all this please save and close the two source files and keep the Summary file open.



Like I said, all new to VBA, I've read quite useful codes on the forum which relate to my problem so I hope someone is able to assist me...

Thanks in advance !!

VBA noobie