Update links automatically

Could somebody please tell me what code i need to write into a macro to remove the pop up box asking you to update links when opening a file??? I want this to be automated and not for my end user to have to click the update button.

Thanks in advance, enjoy your weekends, thank goodness it is friday!!!

--
Hi Paul,

Set the UpddateLinks property of the Open method to True, e,g,:

Workbooks.Open "Book1.xls", UpdateLinks:=True


---
Regards,
Norman



"PaulOakley" <[email protected]> wrote
in message news:[email protected]...
>
> Could somebody please tell me what code i need to write into a macro to
> remove the pop up box asking you to update links when opening a file???
> I want this to be automated and not for my end user to have to click the
> update button.
>
> Thanks in advance, enjoy your weekends, thank goodness it is friday!!!
>
>
> --
> PaulOakley
> ------------------------------------------------------------------------
> PaulOakley's Profile:
> http://www.excelforum.com/member.php...o&userid=25103
> View this thread: http://www.excelforum.com/showthread...hreadid=391227
>

Good morning PaulOakley

You can turn off the box from within Excels options (Tools > Options, Edit, Ask to update automatic links). Unfortunately this is an Excel setting rather than a workbook setting, so is not saved with your workbook. To access this setting via VBA you would use the command:

Application.AskToUpdateLinks = False

But then you would get the dialog box asking if you want to run macros, so to get a dialog free file opening you really need to change the setting in the Options.

Have a nice weekend!

HTH

DominicB