Supressing Update Links Dialog Box
 

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

Supressing Update Links Dialog Box
 

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.


--
Regards,
Tom Ogilvy




"Jeff" wrote in message
...
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

Supressing Update Links Dialog Box
 

Tom Thanks. I would have never figured it out!

"Tom Ogilvy" wrote:

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.


--
Regards,
Tom Ogilvy




"Jeff" wrote in message
...
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