Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Repost: Disabling Update Links dialog box | Excel Discussion (Misc queries) | |||
Disabling Update Links dialog box | Excel Discussion (Misc queries) | |||
Avoid Update Links dialog in Excel 2003 | Links and Linking in Excel | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Disable update links dialog box | Excel Programming |