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
press.com/2011/07/06/compiling-workbooks/ Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-...@googlegroups.com [mailto:excel-...@googlegroups.com ] On Behalf Of SG Sent: 14 December 2012 7:19 To: excel-...@googlegroups.com Subject: $$Excel-Macros$$ Consolidating Multiple fi

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

2012-12-14 Thread SG
.com ] *On Behalf Of *SG > *Sent:* 14 December 2012 7:19 > *To:* excel-...@googlegroups.com > *Subject:* $$Excel-Macros$$ Consolidating Multiple files > > > > Hi Experts, > > > > I need your help in one of my problem.I want to consolidate the > m

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

2012-12-14 Thread Rajan_Verma
[IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of SG Sent: 14 December 2012 7:19 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Consolidating Multiple files Hi Experts, I need your help in one of my problem.I want to consolidate

$$Excel-Macros$$ Consolidating Multiple files

2012-12-14 Thread SG
Hi Experts, I need your help in one of my problem.I want to consolidate the multiple excel files of a folder with same name & numbered as 1,2,3 in to a one excel file.I have tried but unable to create a macro on it.There is only one criteria in this consolidation is that on column D of every s