Rediger

Del via

WorkbookQuery.Delete method (Excel)

  • Artikkel

Deletes this query and its underlying connection and removes it from the Queries collection.

Syntax

expression.Delete(DeleteConnection)

expression A variable that represents a WorkbookQuery object.

Parameters

Name Required/Optional Data type Description
DeleteConnection Optional Variant True To delete the both the query and its underlying connection . The default is False.

Return value

Nothing

Remarks

By default, the underlying connection is not deleted. To delete both the query and the underlying connection, add the parameter (TRUE).

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.