Prev: Start/End Cells in a Range
Next: class modules versus modules
From: p45cal on 15 Apr 2010 12:56

The Updatelinks property is different from the UpdateLink method.
From the UpdateLink help:

---------------------------------
UpdateLink Method
See AlsoApplies ToExampleSpecificsUpdates a Microsoft Excel, DDE, or
OLE link (or links).

expression.UpdateLink(Name, Type)
expression Required. An expression that returns a Workbook object.

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

Type Optional XlLinkType.

XlReferenceStyle can be one of these XlReferenceStyle constants.
xlLinkTypeExcelLinks default.
xlLinkTypeOLELinks (also used for DDE links)

Remark
Note 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
---------------------------------
but I haven't tried it.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=194950

http://www.thecodecage.com/forumz

First  |  Prev  | 
Pages: 1 2
Prev: Start/End Cells in a Range
Next: class modules versus modules