hi, check the below article to do your job easily
http://funwithexcel.blogspot.com/2009/05/how-to-copy-multiple-workbooks-data.html
Hope this helps.
On Wed, May 20, 2009 at 12:02 AM, Atul Kesaria wrote:
> Is there any code where by all the files saved in a particular folder gets
> copied to a pre
Is there any code where by all the files saved in a particular folder gets
copied to a pre defined excel sheet .rather then writing the below code
75 times with different file names.
On Tue, May 19, 2009 at 2:17 PM, ritesh paul wrote:
> you have to write the below code 75 times in VBA
>
> W
you have to write the below code 75 times in VBA
Workbooks.Open ("C:\Documents and Settings\Ritesh\Desktop\temp\A.xls")
Sheets("A").Copy After:=Workbooks("report.xls").Sheets(1)
workbooks("a.xls").close
where A is source file, Report is the fle where dat will be save,
Regards,
paul
On Mon, May
