Unfortunately none of those provide the user with the prompt in the Message
bar. The want the ability to update links sometimes and not others. The
below settings force the updating or not. As I said before I have a
workaround which prompts them with a message box which passes the values to
the UpdateLinks parameter in the Open method. It would be better to use the
built in Excel alert/prompt.

Thanks


"royUK" wrote:


Use somethinbg like

Code:
--------------------

Workbooks.Open FileNmae:= _
"C:\My Documents\test.xls", UpdateLinks:=xlUpdateLinksAlways
--------------------


Alternative settings

xlUpdateLinksNever
xlUpdateLinksUserSetting


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=47414