Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-17 Thread SG
December 2012 8:26 *To:* excel-...@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Consolidating Multiple files may be i'm silly with the question, but really not getting it that you have replied. On Friday, December 14, 2012 8:16:28 PM UTC+5:30, Rajan_Verma wrote: *Ah..* * * *You

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-17 Thread SG
-...@googlegroups.com *Sent:* Fri, December 14, 2012 10:11:52 AM *Subject:* Re: $$Excel-Macros$$ Consolidating Multiple files thanks but the macro is not entering in to the loop. I have edited the macro lil bit at my end.I have removed the part which is for saving the complied file i think it's not going

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-17 Thread ashish koul
*--**--- -- *From:* SG sona...@gmail.com *To:* excel-...@googlegroups.com *Sent:* Fri, December 14, 2012 10:11:52 AM *Subject:* Re: $$Excel-Macros$$ Consolidating Multiple files thanks but the macro is not entering in to the loop

RE: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread Rajan_Verma
See if it helps 1) http://excelpoweruser.wordpress.com/2012/06/07/compile-worksheets/ 2) http://excelpoweruser.wordpress.com/2011/08/12/compiling-workbooks-2/ 3) http://excelpoweruser.wordpress.com/2011/07/06/compiling-workbooks/ Regards Rajan verma +91 7838100659

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread SG
hi Rajan, Thanks for the reply.I have taken the macro from 2nd link. However on running the macro, the code in 4th line 'Dim Fso As New Scripting.FileSystemObject' gives an complie error 'user-defined type not defined'. please help on this. On Friday, December 14, 2012 7:28:17 PM UTC+5:30,

RE: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread Rajan_Verma
Ah.. You can add reference Microsoft scripting runtime Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SG Sent: 14 December 2012 7:54 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread SG
]* * * *From:* excel-...@googlegroups.com javascript: [mailto: excel-...@googlegroups.com javascript:] *On Behalf Of *SG *Sent:* 14 December 2012 7:54 *To:* excel-...@googlegroups.com javascript: *Subject:* Re: $$Excel-Macros$$ Consolidating Multiple files hi Rajan, Thanks

RE: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread Rajan_Verma
@googlegroups.com Subject: Re: $$Excel-Macros$$ Consolidating Multiple files may be i'm silly with the question, but really not getting it that you have replied. On Friday, December 14, 2012 8:16:28 PM UTC+5:30, Rajan_Verma wrote: Ah.. You can add reference Microsoft scripting runtime Regards

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread Paul Schreiner
Wesley - From: SG sonal...@gmail.com To: excel-macros@googlegroups.com Sent: Fri, December 14, 2012 9:55:48 AM Subject: Re: $$Excel-Macros$$ Consolidating Multiple files may be i'm silly with the question, but really

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread SG
*Sent:* 14 December 2012 8:26 *To:* excel-...@googlegroups.com javascript: *Subject:* Re: $$Excel-Macros$$ Consolidating Multiple files may be i'm silly with the question, but really not getting it that you have replied. On Friday, December 14, 2012 8:16:28 PM UTC+5:30, Rajan_Verma

Re: $$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread Paul Schreiner
:11:52 AM Subject: Re: $$Excel-Macros$$ Consolidating Multiple files thanks but the macro is not entering in to the loop. I have edited the macro lil bit at my end.I have removed the part which is for saving the complied file i think it's not going to effect anyway. please suggest.. On Friday