Updating Links

  • Thread starter Thread starter Ashley
  • Start date Start date
A

Ashley

I have an Excel WorkBook called EOH.xls that asks if I
want to Update the Links upon its opening. I am opening
this WorkBook through a VB application that I wrote but
cannot figure out how to open the WorkBook while
automatcially choosing 'NO' to Update the Links message.

I can write code in another Excel WorkBook to open the
EOH.xls WorkBook or by turning off the 'Ask to update
links', but I would like to programmatically do so in my
existing VB application. Is this possible and if so, how?

Any suggestions?
 
Inside xl's VBA, I could do something like:

Dim wkbk As Workbook
Set wkbk = Workbooks.Open(Filename:="book1.xls", UpdateLinks:=0)

Take a look at VBA's help and you'll see some more options for the .open and
updatelinks:= stuff.
 
Back
Top