WebDisableRedirections Property [Excel 2003 VBA Language Reference]

  • Article

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

Applies to | QueryTable Object