Update Links

  • Thread starter Thread starter Roger R
  • Start date Start date
R

Roger R

Last friday I asked the question of how to write VBA that
will make the "Update links" prompt appear when opening a
linked file. I recieved feed back that showed me how:

Workbooks.Open Filename:="c:\test.xls", UpdateLinks:=0

Which works wonderfully, except I must have asked the
question wrong, because I want not only the promt to not
come up, but I DO NOT want the links to be updated. Is
there any way to do this? Also I was directed to "Help on
Update Link Properties" Is this the help in VBA? or on MS
website tutorials, I was confused as to which Help to go
to.
 
UpdateLinks:=0

means that they are not updated

Application.DisplayAlerts = False
Workbooks.Open Filename:="c:\test.xls", UpdateLinks:=0
Application.DisplayAlerts = True

will not prompt you and not update the links
 
Back
Top