Re: $$Excel-Macros$$ Macro needed to add worksheet

2013-09-12 Thread SG
-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On Behalf Of *SG *Sent:* Wednesday, September 11, 2013 5:33 PM *To:* excel-...@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Macro needed to add worksheet Hi Ravi, i think the below code is incomplete.please correct

Re: $$Excel-Macros$$ Macro needed to add worksheet

2013-09-11 Thread SG
:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *SG *Sent:* Tuesday, September 10, 2013 2:36 PM *To:* excel-...@googlegroups.com javascript: *Subject:* Re: $$Excel-Macros$$ Macro needed to add worksheet Thanks for the help but it's

Re: $$Excel-Macros$$ Macro needed to add worksheet

2013-09-11 Thread SG
:* Tuesday, September 10, 2013 2:36 PM *To:* excel-...@googlegroups.com javascript: *Subject:* Re: $$Excel-Macros$$ Macro needed to add worksheet ** ** Thanks for the help but it's not adding my sheet in rest of the workbooks. i have attached that single sheet added the macro

RE: $$Excel-Macros$$ Macro needed to add worksheet

2013-09-11 Thread Ravi Kumar
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SG Sent: Wednesday, September 11, 2013 5:33 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro needed to add worksheet Hi Ravi, i think the below code is incomplete.please correct me if i'm

Re: $$Excel-Macros$$ Macro needed to add worksheet

2013-09-11 Thread SG
:* Wednesday, September 11, 2013 5:33 PM *To:* excel-...@googlegroups.com javascript: *Subject:* Re: $$Excel-Macros$$ Macro needed to add worksheet Hi Ravi, i think the below code is incomplete.please correct me if i'm wrong. Workbooks(primewb).Sheets(sample).Range(A4

Re: $$Excel-Macros$$ Macro needed to add worksheet

2013-09-10 Thread SG
Thanks for the help but it's not adding my sheet in rest of the workbooks. i have attached that single sheet added the macro in it.Please suggest Where i'm going wrong. On Monday, September 9, 2013 8:16:20 PM UTC+5:30, ashish wrote: Sub copy_sheet() Application.ScreenUpdating = False

RE: $$Excel-Macros$$ Macro needed to add worksheet

2013-09-10 Thread Ravi Kumar
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SG Sent: Tuesday, September 10, 2013 2:36 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Macro needed to add worksheet Thanks for the help but it's not adding my sheet in rest of the workbooks. i have

Re: $$Excel-Macros$$ Macro needed to add worksheet

2013-09-10 Thread ashish koul
:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *SG *Sent:* Tuesday, September 10, 2013 2:36 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Macro needed to add worksheet ** ** Thanks for the help but it's not adding my sheet

Re: $$Excel-Macros$$ Macro needed to add worksheet

2013-09-09 Thread ashish koul
Sub copy_sheet() Application.ScreenUpdating = False Application.DisplayAlerts = False Dim fld As Object, fil As Object, fso As Object Dim wkb As Workbook Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(C:\Users\admin\Desktop\test) ' folder having files For Each fil