View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Update link answer = no

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