LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 371
Default DoEvents??

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Doevents Application Alex J Excel Programming 1 November 30th 03 04:31 PM


All times are GMT +1. The time now is 10:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"