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

2012-12-17 Thread ashish koul
removed the part which >>> is for saving the complied file & i think it's not going to effect anyway. >>> please suggest.. >>> >>> On Friday, December 14, 2012 8:31:22 PM UTC+5:30, Rajan_Verma wrote: >>> >>>> *Ok,* >>>> >

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

2012-12-17 Thread SG
ou can, >> By all the means you can, >> In all the ways you can, >> In all the places you can, >> At all the times you can, >> To all the people you can, >> As long as ever you can.” - John Wesley >> *- >> >> >> -- >> *From:* SG >&g

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

2012-12-17 Thread SG
; >> *Goto the Tool- Reference –Select **Microsoft scripting runtime*** >> >> * * >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> * * >> >> *From:* excel-...@googlegroups.com [

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

2012-12-14 Thread Paul Schreiner
t: 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 to e

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

2012-12-14 Thread SG
glegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *SG > *Sent:* 14 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 getti

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

2012-12-14 Thread Paul Schreiner
As long as ever you can.” - John Wesley - From: SG 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, bu

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 scripti

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

2012-12-14 Thread SG
*Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-...@googlegroups.com [mailto: > excel-...@googlegroups.com ] *On Behalf Of *SG > *Sent:* 14 December 2012 7:54 > *To:* excel-...@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Consolidati

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: $$Ex

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, Raj

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 [IM