WebDisableRedirections Property
True if Web query redirections are disabled for a QueryTable object. The default value is False. Read/write Boolean.
expression.WebDisableRedirections
expression Required. An expression that returns one of the objects in the Applies To list.
Example
In this example, Microsoft Excel determines the settings 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