| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to make code waiting until Outlook finishes its job
Hi all,
I activate Outlook in code and like to make the code wait until Outlook is done.How can I do it? Clara -- thank you so much for your help |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How to make code waiting until Outlook finishes its job
This causes a 10 second pause. You can set it for whatever amount of time
seems appropriate. newHour = Hour(Now()) newMinute = Minute(Now()) newSecond = Second(Now()) + 10 waitTime = TimeSerial(newHour, newMinute, newSecond) Application.Wait waitTime -- Best wishes, Jim "clara" wrote: Hi all, I activate Outlook in code and like to make the code wait until Outlook is done.How can I do it? Clara -- thank you so much for your help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro finishes faster when left clicking during execution | Excel Programming | |||
| How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
| How can I use Outlook express to send mail rather than Outlook by VBA code | Excel Programming | |||
| Pausing procedure until worksheet finishes calculating | Excel Programming | |||
| Excel code to Wait until Word finishes printing before closing | Excel Programming | |||
Hybrid Mode
