Update link answer = no

[Guest]

Hi, I just wanted to automatically say no to a msgbox asking if I want to
update the links in a workbook opened by a macro.
I cannot Select Edit-->Link, because the workbook opened is changed by
someone I don't know and my macro have just to treat his/her file.

Thanks!
Daniel (Brazil)

 

[Dave Peterson]

Can you change the code to not update links:

Set wkbk = Workbooks.Open(Filename:=SomeFileNameHere, UpdateLinks:=0)

(see VBA's help for more info)

 

[Guest]

You can set the UpdateLinks parameter to False when you open the workbook..

Application.Workbooks.Open Filename:="D:\TEMP\sample.xls", UpdateLinks:=False

 

[Guest]

I found myself the answer. There is a command:

, UpdateLinks:=False that I have to put just after the filename:=
"mybook.xls".

 

[Guest]

Thanks Adriano, I've also found myself.

You can set the UpdateLinks parameter to False when you open the workbook..

Application.Workbooks.Open Filename:="D:\TEMP\sample.xls", UpdateLinks:=False