Hi there,

I am totally new to VBA coding but I have a good understanding of "coding"! This will be my first job. I need to import data from a workbook which is saved everyday from the system with the same name, lets say "Data", and the worksheet name which I want to extract the data from is named "Sheet1". The address in my network is also constant say "C:\Bank". So I want to pull data from "C:\Bank", "Data.xls", "Sheet1"; then put it in my current Excel Workbook, lets name it "Report", and in the worksheet "Sheet2".
After some manupulation (with vba), I would like to "save as" the file with the same name but with a suffix of the date that I am reporting, for example: "Report - 23 January 2013" in a new folder say "C:\Bank Reports".

Can someone help me please?

Thanks in advance!
-Taha