Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

2011-09-13 Thread dguillett1
eWorkbookBasedOnList() For i = 1 To 2 ActiveWorkbook.SaveAs "C:\thisfolder\book" & Cells(i, 1) & ".xls" Next i ActiveWorkbook.Close End Sub From: SridharBL Sent: Tuesday, September 13, 2011 6:49 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

2011-09-13 Thread SridharBL
Don, What the difference b/w your code and Ashish code??? Thanks Sridhar BL -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join o

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

2011-09-12 Thread dguillett1
xt i End Sub From: ashish koul Sent: Wednesday, September 07, 2011 9:34 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files Hi, Sub test() For i = 1 To 10 ThisWorkbook.Sheets(Array("Sheet1", "Sheet2")).Copy Acti

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

2011-09-12 Thread SridharBL
Hi Ashish, appreciate you help. The code is partly okay. The above code created a new files with those x and y sheets. Can you alter the above macro code, so that those x and y sheets will get pasted to already existing (12)files? Appreciate your help once again. Regards, Sridhar BL --

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

2011-09-07 Thread ashish koul
Hi, Sub test() For i = 1 To 10 ThisWorkbook.Sheets(Array("Sheet1", "Sheet2")).Copy ActiveWorkbook.SaveAs "C:\Documents and Settings\ASHISH\Desktop\ABC\book" & i & ".xlsx" ActiveWorkbook.Close Next i End Sub On Wed, Sep 7, 2011 at 5:29 PM, SridharBL wrote: > Ashish, > > I need to save the shee

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

2011-09-07 Thread SridharBL
Ashish, I need to save the sheets of One Workbook to 12 other workbooks. Say, I have One Master excel work book with sheets x and y. These x and y sheets should be moved to other 12 workbooks. So, now all the 12 Work books will have x & y sheets as of Master excel work book. Thanks, Sridhar

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

2011-09-06 Thread ashish koul
Hi Sridhar do you want to save your sheet in 12 new workbooks or you want to add the sheet to existing 12 workbooks On Tue, Sep 6, 2011 at 3:01 PM, SridharBL wrote: > Hi Noorain, > > The code in the weblink did not work. > > This just created a new workbook with a single sheet. > > > Apprecia

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

2011-09-06 Thread SridharBL
Hi Noorain, The code in the weblink did not work. This just created a new workbook with a single sheet. Appreciate for any other options.. Regards, Sridhar BL -- -- Some important links for excel users: 1. Follo

Re: $$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

2011-09-05 Thread NOORAIN ANSARI
Dear Sridhar, Please use below link to solve ur query http://akoul.blogspot.com/search/label/Merge%20Data%20from%20multiple%20workbooks%20for%20specific%20sheets%20only http://akoul.blogspot.com/search/label/Merge%20Data%20from%20sheet%201%20from%20multiple%20workbooks%20to%20

$$Excel-Macros$$ Macro to Copy the sheets from One file to Multiple Files

2011-09-05 Thread SridharBL
Dear Experts, I would request a macro, which can copy the Sheets(two) from one Master file to other different Excel Files(12 files). I would appreciate your help in this matter. Thanks, Sridhar BL -- -- Some impor