ExcelBanter - Waiting for OLE action

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Waiting for OLE action (https://www.excelbanter.com/excel-programming/311228-waiting-ole-action.html)

Ingvar E

Waiting for OLE action

Is there anyway to make Excel wait longer for another
program to complete an OLE action? I am in control of the
Excel VBA code.

No Name

Waiting for OLE action

'Application.Wait (Now() + TimeValue("0:00:02"))
this waits 2 seconds.
-----Original Message-----
Is there anyway to make Excel wait longer for another
program to complete an OLE action? I am in control of the
Excel VBA code.
.

Ingvar

Waiting for OLE action

Hmm, Yes.
But that is a "hard wait" that might cause a longer wait
than is neccessary wouldnt it? I would like to say: Wait,
but not longer than 20 seconds. If the other program
finishes in 10 seconds stop waiting then.

-----Original Message-----
'Application.Wait (Now() + TimeValue("0:00:02"))
this waits 2 seconds.
-----Original Message-----
Is there anyway to make Excel wait longer for another
program to complete an OLE action? I am in control of
the
Excel VBA code.
.

.

All times are GMT +1. The time now is 08:36 AM.