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)

Can you change the code to not update links:

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

(see VBA's help for more info)

dspilberg wrote:

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

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

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


--
Hope that helps.

Vergel Adriano


"dspilberg" wrote:

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)

I found myself the answer. There is a command:

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




"dspilberg" wrote:

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)

Thanks Adriano, I've also found myself.

"Vergel Adriano" wrote:

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

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


--
Hope that helps.

Vergel Adriano


"dspilberg" wrote:

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)