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,*
>>>>
>
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
;
>> *Goto the Tool- Reference –Select **Microsoft scripting runtime***
>>
>> * *
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> * *
>>
>> *From:* excel-...@googlegroups.com [
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
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
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
@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
*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
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
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
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
11 matches
Mail list logo