Application.ODBCTimeout Property (Excel)
Returns or sets the ODBC query time limit, in seconds. The default value is 45 seconds. Read/write Long.
Syntax
expression .ODBCTimeout
expression A variable that represents an Application object.
Remarks
The value 0 (zero) indicates an indefinite time limit.
Example
This example sets the ODBC query time limit to 15 seconds.
Application.ODBCTimeout = 15