WorkbookConnection.Delete Method (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Deletes a workbook connection.

expression .Delete

expression A variable that represents a WorkbookConnection object.

Use this method to delete an external data connection. This method does not apply to links to other workbooks.

Deleting a connection will not delete or remove any objects that were using that connection. Deleting a connection will not cause any of the connection files to be deleted from the file system. If you edit any of those objects to use another connection, everything will start working again.

Objects that use a deleted connection behave as if the connection could not be established.

Show: