The problem is with regard to a Windows Application "Instance". Basically, when you open more than one workbook, the Excel "program" opens once, and each workbook is open in this single "instance" of Excel.
That's why, in earlier versions of Excel, you had a "window" menu selection that listed the open workbooks. It's kind-of like having a car with multiple passengers. When you start the engine (like a macro), all passengers are using the same engine. If, while the engine is running, another passenger gets in, they don't bring their own engine! In your case, the macro is interrupted because the act of opening the new workbook "takes over" the Excel session. it IS possible to open the Excel program more than once! (create multiple "instances" of Excel) Most computers today can handle several instances without suffering significantly (depending on the complexity of the macro running). Depending on your version of Windows and Excel, the technique for opening multiple instances differs. You can Google "Multiple Excel Instances" and look for your version. Paul ----------------------------------------- “Do all the good you 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: sreekanth m <sreekanthm.namb...@gmail.com> To: excel-macros <excel-macros@googlegroups.com> Sent: Fri, April 26, 2013 5:11:33 AM Subject: $$Excel-Macros$$ Macro getting stopped Hi Experts, I have a macro to compare two folders carrying Excel files and if I open any other Excel file during the Macro Execution, the macro is getting Stopped. Is it a normal behaviour of Excel or what can be the root cause of this problem? Please advise me ASAP. Thanks -- Thanks&Regards, Sreekanth M Mobile:8095220421-- 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.
