OLEDBConnection.RefreshPeriod (Excel)

Returns or sets the number of minutes between refreshes.

Setting the period to 0 (zero) disables automatic timed refreshes and is equivalent to setting this property to Null. The value of the RefreshPeriod property can be an integer from 0 through 32767.

ActiveWorkbook.Connections(1).OLEDBConnection.RefreshPeriod =