Automatically selecting "Do not update links" when VBA loads excel doc

[VBAguy22]

Hi
I am loading another Excel document from my current one programatically using Open function.
The loaded file has links and the pop up menu keeps appearing every time i load it asking me if I want to update links. I set display alerts to false, but it's still doing it.
What is the command to set "Do not update links" to default and avoid the pop up box?

THNX!

 

[PHV]

USe UpdateLinks:=False when you call the Workbooks.Open method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886