View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] marston.gould@alaskaair.com is offline
external usenet poster
 
Posts: 102
Default Two odd application issues

Has anyone every seen this and does anyone have a solution?

Often, if I'm running by VBA code, if I switch to another application
during the process where Excel is opening files and copying data into
arrays in the program, it stops. I've noticed that this doesn't occur
as I start the program, but during it.

Also, if I switch to another application and then come back,
even the code continues to run, the Application.StatusBar stops
updating, even though I know its receiving updates. It doesn't stop the
program, but it does give the user the perception that it has stopped.