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
-...@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
*--**---
--
*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
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
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,
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
]*
* *
*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
@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
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
*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
: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
11 matches
Mail list logo