update links question

[Gary Keramidas]

i'm not sure if the client's settings are going to be set to auto update links
or not. in the workbook, under edit/links , i set the startup prompt to "don't
display the alert and update links". it still prompts. i tried workbook open
code:

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources

still get the prompt. how do i programmatically turn it off? the workbook is set
to read only recommended.

 

[Dave Peterson]

Excel notices the links before your code starts. So anything you do in this
workbook, won't help this workbook--but will "help" the next one.

If you really want more control over how the workbook gets opened, one way is to
build another workbook that opens the real workbook while controlling how it
should be opened.

Saved from a previous post:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)

Then have the users open the dummy workbook.

(See help for those Updatelinks options)

 

[Gary Keramidas]

ok, thanks dave.

--


Gary

Excel notices the links before your code starts. So anything you do in this
workbook, won't help this workbook--but will "help" the next one.

If you really want more control over how the workbook gets opened, one way is
to
build another workbook that opens the real workbook while controlling how it
should be opened.

Saved from a previous post:

Kind of like:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=1
ThisWorkbook.Close savechanges:=False
End Sub

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)

Then have the users open the dummy workbook.

(See help for those Updatelinks options)