QueryTable.WebDisableRedirections Property

Syntax

expression.WebDisableRedirections

expression A variable that represents a QueryTable object.

Example

In this example, Microsoft Excel determines the settings of Web query redirections for the first worksheet in the workbook. This example assumes a QueryTable object exists on the first worksheet, otherwise a run-time error will occur.

Sub CheckWebQuerySetting() Dim wksSheet As Worksheet Set wksSheet = Application.ActiveSheet MsgBox wksSheet.QueryTables(1).WebDisableRedirections End Sub

See also:

• QueryTable Object
• QueryTable Object Members