Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have recently put a modal form onto a networked pc. The pc has its own
stand-alone version of Excel installed. The form can take several minutes to complete and it has been reported that very occasionally in the middle of completion, Excel crashes with a serious error. This is more likely if there has been an interuption during completion and 'several' minutes turns out to be 15 or even longer. (There is a Hide button on the form for this reason and also to facilitate reference to other files. I am reasonably confident this functionality does not cause conflicts) When the form completes ok (great majority of occasions) and control is released back to the application there is a period of several seconds when the busy icon is visible and the pc 'catches up' with its 'housework'. I have 2 questions: 1. Can the demands of a network 'intefere' with the running of a modal form? For instance I know the network polls for emails every 30 minutes from a central point elsewhere. 2. Should I be releasing control back to the application at various stages during completion of the form by liberally using DoEvents? T.I.A. Geoff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Doevents Application | Excel Programming |