WebDisableRedirections Property

Microsoft Excel Visual Basic

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 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