You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Open another different excel file
- Thread starter James989
- Start date
James989
You should 'tell' to Your running macro that something else could do too.
eg if You have there loops then useDoEventsfunction.
Before this, I am able to open up to max 8 different file and run the macro of each file(I never use DoEvents) ! Off course, I open it one by one . . .
However, after re-installation(due to computer problem) MS office 2016, I only can open 1 excel and run the macro, when try to open the second file, it just keep loading and not able to open it.
So, what is the problem ?
Are You Excel settings same now? Yes/No?
Are You opening next Excel-file while macro is running? Yes/No?
Can You open that 2nd Excel-file alone? ... before Your 1st Excel-file ... Is that file Okay? Yes/No?
It would help You, if You could write exact - what are You doing? what happens? without missing any details.
Are You opening next Excel-file while macro is running? Yes/No?
Can You open that 2nd Excel-file alone? ... before Your 1st Excel-file ... Is that file Okay? Yes/No?
It would help You, if You could write exact - what are You doing? what happens? without missing any details.
1) Yes. However, what important setting should I look into ?
2) While one next Excel-file macro is running, I try to open other excel file but failed( keep loading)
3) Yes, can open 2nd excel file alone and run macro of this 2nd file.
Can you try to run macro of your own excel file? While running macro, are you able open another second excel file ?
Please note that both first and second file have their own macro.
2) While one next Excel-file macro is running, I try to open other excel file but failed( keep loading)
3) Yes, can open 2nd excel file alone and run macro of this 2nd file.
Can you try to run macro of your own excel file? While running macro, are you able open another second excel file ?
Please note that both first and second file have their own macro.
Last edited:
1) Yes.
... If You answer 'Yes' ... then that should mean 'Yes' ... but seems that You start to thinking something ... at least You named different versions.
2) ... yes. ...then those
3) So file should be okay ... but can You then open other files?
Can I ...
Yes, I can - if macro is written so.
... but normally, I won't do so - because, I'm not so so so hurry.
... If You answer 'Yes' ... then that should mean 'Yes' ... but seems that You start to thinking something ... at least You named different versions.
2) ... yes. ...then those
DoEvents could help3) So file should be okay ... but can You then open other files?
Can I ...
Yes, I can - if macro is written so.
... but normally, I won't do so - because, I'm not so so so hurry.