Supressing Update Links Dialog Box

[Guest]

I want to open a file into the background so that when the user is working on
the main sheet, updates carried out by VBA can access the file without the
user knowing where the file is actually located.


I am using the following code:
Set xlApp = GetObject(, "Excel.Application")
xlApp.Application.DisplayAlerts = False
Workbooks.Open ("\\v1sacpdofc2\cpdprojects\CIS Financials\Costs
Projections - bottom up\Nov 04 actuals to end of program - reduced
scope\Gantt Planner Novemeber 2004 Incl New R3.xls")
xlApp.Application.DisplayAlerts = True

However I am always prompted to update the links. I want to always choose no
or have the message never appear.

Jeff

 

[Tom Ogilvy]

Workbooks.Open "\\v1sacpdofc2\cpdprojects\CIS Financials\Costs
Projections - bottom up\Nov 04 actuals to end of program - reduced
scope\Gantt Planner Novemeber 2004 Incl New R3.xls", UpdateLinks:=0

change 0 to the option you want. See help for details.

 

[Guest]

Tom Thanks. I would have never figured it out!

Workbooks.Open "\\v1sacpdofc2\cpdprojects\CIS Financials\Costs
Projections - bottom up\Nov 04 actuals to end of program - reduced
scope\Gantt Planner Novemeber 2004 Incl New R3.xls", UpdateLinks:=0

change 0 to the option you want. See help for details.