Partager via


_QueryTable.EditWebPage Property

Returns or sets the web page uniform resource locator (URL) for a web query. Read/write Object.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property EditWebPage As Object
    Get
    Set
'Usage
Dim instance As _QueryTable
Dim value As Object

value = instance.EditWebPage

instance.EditWebPage = value
Object EditWebPage { get; set; }

Property Value

Type: System.Object

Remarks

The EditWebPage property returns Null if not set. The EditWebPage property is only meaningful if the query type is xlWebQuery or xlOLEDBQuery.

If the EditWebPage is not null, ignore the WebTables property for refreshing. As a result an XML query and the WebTable property refers to the table in the original Web page and should only be used in the edit case to pre-populate the Web Query dialog box.

See Also

Reference

_QueryTable Interface

_QueryTable Members

Microsoft.Office.Interop.Excel Namespace