Re: $$Excel-Macros$$ Different Excel file in one Excel file

2013-04-11 Thread Abhishek Jain 
Your requirement is not clear.

Do you want to open the files as per your choice or you also want to merge
their data? If its latter, do all files have data in same format? What did
you mean by tick boxes? There is no screenshot / sample file with your
query.

Please elaborate.

Regards,


On Thu, Apr 11, 2013 at 4:15 PM, Ganesh Acharya
wrote:

>
>Hi,
>>  Can someone please help me out with the macro for below thing
>>  If I saved the different excel file in one folder for ex : - 15 excel
>> file with different name  among them if i want to choose the 5 file as
>> per my choice   If I want to only 6 file which I required so that it can
>> merge all the data into the one excel file.
>>  For Example: As per below If I tick only 2 box it would extract only
>> two file into main file.  It depends on my tick, if there is 3 tick than
>> 3 excel file as per my requirement .
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Thanks and Regards  Ganesh Acharya
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>  FORUM RULES
>>  1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.  2) Don't post a
>> question in the thread of another member.  3) Don't post questions
>> regarding breaking or bypassing any security measure.  4) Acknowledge
>> the responses you receive, good or bad.  5) Jobs posting is not allowed.  6)
>> Sharing copyrighted material and their links is not allowed.
>>  NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and members are not responsible for any loss.  ---  You received this
>> message because you are subscribed to the Google Groups "MS EXCEL AND VBA
>> MACROS" group.  To unsubscribe from this group and stop receiving emails
>> from it, send an email to 
>> excel-macros+unsubscr...@googlegroups.com.
>>   To
>> post to this group, send email to 
>> excel-macros@googlegroups.com.  Visit
>> this group at 
>> http://groups.google.com/group/excel-macros?hl=en.
>>   For
>> more options, visit 
>> https://groups.google.com/groups/opt_out.
>>  --  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
>> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>  FORUM RULES
>>  1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.  2) Don't post a
>> question in the thread of another member.  3) Don't post questions
>> regarding breaking or bypassing any security measure.  4) Acknowledge
>> the responses you receive, good or bad.  5) Jobs posting is not allowed.  6)
>> Sharing copyrighted material and their links is not allowed.
>>  NOTE : Don't ever post confidential data in a workbook. Forum owners
>> and members are not responsible for any loss.  ---  You received this
>> message because you are subscribed to the Google Groups "MS EXCEL AND VBA
>> MACROS" group.  To unsubscribe from this group and stop receiving emails
>> from it, send an email to 
>> excel-macros+unsubscr...@googlegroups.com.
>>   To
>> post to this group, send email to 
>> excel-macros@googlegroups.com.  Visit
>> this group at 
>> http://groups.google.com/group/excel-macros?hl=en.
>>   For
>> more options, visit 
>> https://groups.google.com/groups/opt_out.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
>> For more options, v

Re: $$Excel-Macros$$ Different Excel file in one Excel file

2013-04-11 Thread Ganesh Acharya 
>Hi,
>  Can someone please help me out with the macro for below thing
>  If I saved the different excel file in one folder for ex : - 15 excel
> file with different name  among them if i want to choose the 5 file as
> per my choice   If I want to only 6 file which I required so that it can
> merge all the data into the one excel file.
>  For Example: As per below If I tick only 2 box it would extract only two
> file into main file.  It depends on my tick, if there is 3 tick than 3
> excel file as per my requirement .
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> Thanks and Regards  Ganesh Acharya
>
>
>
>
>
>
>
>
>
>
>
>
>  FORUM RULES
>  1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.  2) Don't post a
> question in the thread of another member.  3) Don't post questions
> regarding breaking or bypassing any security measure.  4) Acknowledge the
> responses you receive, good or bad.  5) Jobs posting is not allowed.  6)
> Sharing copyrighted material and their links is not allowed.
>  NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.  ---  You received this message
> because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS"
> group.  To unsubscribe from this group and stop receiving emails from it,
> send an email to 
> excel-macros+unsubscr...@googlegroups.com.
>   To
> post to this group, send email to 
> excel-macros@googlegroups.com.  Visit
> this group at 
> http://groups.google.com/group/excel-macros?hl=en.
>   For
> more options, visit 
> https://groups.google.com/groups/opt_out.
>  --  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>  FORUM RULES
>  1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.  2) Don't post a
> question in the thread of another member.  3) Don't post questions
> regarding breaking or bypassing any security measure.  4) Acknowledge the
> responses you receive, good or bad.  5) Jobs posting is not allowed.  6)
> Sharing copyrighted material and their links is not allowed.
>  NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.  ---  You received this message
> because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS"
> group.  To unsubscribe from this group and stop receiving emails from it,
> send an email to 
> excel-macros+unsubscr...@googlegroups.com.
>   To
> post to this group, send email to 
> excel-macros@googlegroups.com.  Visit
> this group at 
> http://groups.google.com/group/excel-macros?hl=en.
>   For
> more options, visit 
> https://groups.google.com/groups/opt_out.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a que

Fwd: $$Excel-Macros$$ Different Excel file in one Excel file

2013-03-31 Thread Ganesh Acharya 
-- Forwarded message --
From: Ganesh Acharya 
Date: Thu, Mar 28, 2013 at 12:35 PM
Subject: $$Excel-Macros$$ Different Excel file in one Excel file
To: excel-macros@googlegroups.com


   Hi,
 Can someone please help me out with the macro for below thing
 If I saved the different excel file in one folder for ex : - 15 excel file
with different name  among them if i want to choose the 5 file as per my
choice   If I want to only 6 file which I required so that it can merge all
the data into the one excel file.
 For Example: As per below If I tick only 2 box it would extract only two
file into main file.  It depends on my tick, if there is 3 tick than 3
excel file as per my requirement .

























Thanks and Regards  Ganesh Acharya












 FORUM RULES
 1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.  2) Don't post a
question in the thread of another member.  3) Don't post questions
regarding breaking or bypassing any security measure.  4) Acknowledge the
responses you receive, good or bad.  5) Jobs posting is not allowed.  6)
Sharing copyrighted material and their links is not allowed.
 NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.  ---  You received this message
because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS"
group.  To unsubscribe from this group and stop receiving emails from it,
send an email to
excel-macros+unsubscr...@googlegroups.com.
 To
post to this group, send email to
excel-macros@googlegroups.com.  Visit
this group at 
http://groups.google.com/group/excel-macros?hl=en.<http://groups.google.com/group/excel-macros?hl=en>
 For
more options, visit
https://groups.google.com/groups/opt_out.<https://groups.google.com/groups/opt_out>
 --  Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel<https://www.facebook.com/discussexcel>
 FORUM RULES
 1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.  2) Don't post a
question in the thread of another member.  3) Don't post questions
regarding breaking or bypassing any security measure.  4) Acknowledge the
responses you receive, good or bad.  5) Jobs posting is not allowed.  6)
Sharing copyrighted material and their links is not allowed.
 NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.  ---  You received this message
because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS"
group.  To unsubscribe from this group and stop receiving emails from it,
send an email to
excel-macros+unsubscr...@googlegroups.com.
 To
post to this group, send email to
excel-macros@googlegroups.com.  Visit
this group at 
http://groups.google.com/group/excel-macros?hl=en.<http://groups.google.com/group/excel-macros?hl=en>
 For
more options, visit
https://groups.google.com/groups/opt_out.<https://groups.google.com/groups/opt_out>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Probl