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 <riteshkp...@gmail.com> wrote: > 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 18, 2009 at 6:40 AM, Financeguy <velocity...@gmail.com> wrote: > >> >> I would like to execute a batch routine using VBA from an Excel file, >> to be able to call various Excel files in a folder and copy cells from >> sheet name assumptions range A1:Z1000 into a new tab from where I am >> executing the batch. The objective is to pull data from multiple >> files in a folder into a consolidated Excel spreadsheet using VBA >> routine. I intend to pull the data from approximately 75 Excel files. >> Any help on the VBA routine would be much appreciated. >> >> >> > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---