G
GP
I have written a VBA application that takes about 20-30 minutes to iterate
through a series in nested for..next loops. In order to allow me to use
Outlook while the app is running I have inserted a pause/doevents loop inside
the innermost for..next loop as follows:
AppNow = Timer
Do While Timer < AppNow + 1
DoEvents
Loop
This yields to other events for one second, and does allow me to carry on
using Outlook for other things. The only problem is that the preview pane
"freezes" and will not refresh. Increaseing the pause time makes no
differance.
Any ideas on how to solve this problem and get the preview pane to refresh
while the app is running?
through a series in nested for..next loops. In order to allow me to use
Outlook while the app is running I have inserted a pause/doevents loop inside
the innermost for..next loop as follows:
AppNow = Timer
Do While Timer < AppNow + 1
DoEvents
Loop
This yields to other events for one second, and does allow me to carry on
using Outlook for other things. The only problem is that the preview pane
"freezes" and will not refresh. Increaseing the pause time makes no
differance.
Any ideas on how to solve this problem and get the preview pane to refresh
while the app is running?