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 <acharyaganesh...@gmail.com>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.<excel-macros%2bunsubscr...@googlegroups.com> >> To >> post to this group, send email to >> excel-macros@googlegroups.com.<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.<excel-macros%2bunsubscr...@googlegroups.com> >> To >> post to this group, send email to >> excel-macros@googlegroups.com.<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 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.