O
Otto Moehrbach
Excel XP & Win XP
I have 2 workbooks.
One wb is open, the other closed.
They both have the same exact code and lots of it, except for one additional
module in the open wb.
I run the code in that one module in the open wb.
The object is to update worksheet data in the open wb from the closed wb.
The problem I am describing occurs when the closed wb is opened.
I step through the code (F8).
I get to the following code:
Application.EnableEvents = False
Set wbFile2 = Workbooks.Open(ThePath & TheFile)
Application.EnableEvents = True
and the screen starts jumping around with visual effects. Pieces of scroll
bars, title bars, etc appear and disappear virtually everywhere on the
screen. Finally, all this action stops and the closed file is now open.
My question: What is happening and why and is this a problem? Thanks for
your time. Otto
I have 2 workbooks.
One wb is open, the other closed.
They both have the same exact code and lots of it, except for one additional
module in the open wb.
I run the code in that one module in the open wb.
The object is to update worksheet data in the open wb from the closed wb.
The problem I am describing occurs when the closed wb is opened.
I step through the code (F8).
I get to the following code:
Application.EnableEvents = False
Set wbFile2 = Workbooks.Open(ThePath & TheFile)
Application.EnableEvents = True
and the screen starts jumping around with visual effects. Pieces of scroll
bars, title bars, etc appear and disappear virtually everywhere on the
screen. Finally, all this action stops and the closed file is now open.
My question: What is happening and why and is this a problem? Thanks for
your time. Otto