共用方式為


Workbook.UpdateLink Method (Excel)

Updates a Microsoft Excel, DDE, or OLE link (or links).

Syntax

expression .UpdateLink(Name, Type)

expression A variable that represents a Workbook object.

Parameters

Name

Required/Optional

Data Type

Description

Name

Optional

Variant

The name of the Microsoft Excel or DDE/OLE link to be updated, as returned from the LinkSources method.

Type

Optional

Variant

One of the constants of XlLinkType specifying the type of link.

Remarks

When the UpdateLink method is called without any parameters, Excel defaults to updating all worksheet links.

Example

This example updates all links in the active workbook.

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

請參閱

概念

Workbook Object

Workbook Object Members