Update links automatically
 

Could somebody please tell me what code i need to write into a macro t
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 th
update button.

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

--
PaulOakle
-----------------------------------------------------------------------
PaulOakley's Profile: http://www.excelforum.com/member.php...fo&userid=2510
View this thread: http://www.excelforum.com/showthread.php?threadid=39122

Update links automatically
 

--
Hi Paul,

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

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


---
Regards,
Norman



"PaulOakley" wrote
in message ...

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

Update links automatically
 

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 Exce
setting rather than a workbook setting, so is not saved with you
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 th
setting in the Options.

Have a nice weekend!

HTH

Dominic

--
dominic
-----------------------------------------------------------------------
dominicb's Profile: http://www.excelforum.com/member.php...fo&userid=1893
View this thread: http://www.excelforum.com/showthread.php?threadid=39122