Hi sir, and thank you for your assistance. I like your macro very much. Sadly, it does not bring joy. However, it has helped me to discover that the problem is not with my system or version of Excel. The problem is with the target files, which cause cause Excel to crash on opening. I suspect that the files have been saved in Excel 2010 (is that Excel 13?) with features inimical to Excel 2007.
I regret the wild goose chase down a blind alley, yet I am profoundly grateful for the aid and the neat macro that you have provided. I will have to mark this problem "Solved" Warm regards, -Sean- On Oct 20, 10:19 pm, ashish koul <koul.ash...@gmail.com> wrote: > hi Sean > try this macro. select the folder which is having all the excel files. > > > On Fri, Oct 21, 2011 at 2:08 AM, Sean <flanagan.se...@gmail.com> wrote: > > Hi and thanks for your interest in my post. > > > Regards, > > -Sean- > > > -- > > > --------------------------------------------------------------------------- > > ------- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/discussexcel > > -- > *Regards* > * * > *Ashish Koul* > *http://www.excelvbamacros.com/* > > P Before printing, think about the environment. > > MERGE DATA MACRO.xlsm > 27KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
