This documentation is archived and is not being maintained.

WebDisableRedirections Property [Excel 2003 VBA Language Reference]

Office 2003

True if Web query redirections are disabled for a QueryTable object. The default value is False. Read/write Boolean.


expression Required. An expression that returns one of the objects in the Applies To list.


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