Excel file open Update automatically 1

[thevulture]

Hi,

I'm trying to write some VBA code that will open a file, stifle all alerts, and say yes to the "This workbook contains links to other data sources. Update?". I can pretty much do everything but the automatic clicking of the "update" button in the pop up when I open the file. Anyone know how to handle this?

Thanks in advance.

 

[joerd]

Try

Workbooks.Open FileName:="dummy.xls", UpdateLinks:=False


Cheers,

Joerd