Application.Displayalerts wont get me past this!

[andycharger]

I have a spreadsheet that needs a user input.


It says
"This workbook contains links to other data sources

If you update this, Excel attempts to retrieve the latest data.
If you dont update, excel uses the existing data"

There are 3 buttons, Update, Dont Update and Cancel.

I want it to just press the Update option as its highlighted and carr
on but application.Displayalerts = False does not get it past it.

Any ideas

 

[Jim Rech]

It's always great if posters mention their Excel version. If you have Excel
2002 or 2003 the Edit, Links dialog has a "Startup Prompt" button where you
can tailor the prompt, including not having one (which is heaven in my
book).

--
Jim Rech
Excel MVP
|I have a spreadsheet that needs a user input.
|
|
| It says
| "This workbook contains links to other data sources
|
| If you update this, Excel attempts to retrieve the latest data.
| If you dont update, excel uses the existing data"
|
| There are 3 buttons, Update, Dont Update and Cancel.
|
| I want it to just press the Update option as its highlighted and carry
| on but application.Displayalerts = False does not get it past it.
|
| Any ideas?
|
|
| ---
| Message posted
|

 

[Jake Marx]

Hi Andy,

It sounds like you're opening the workbook via code. If that's the case,
you can use the UpdateLinks argument to the Open method. So if you want to
update links automatically, you can do this:

Workbooks.Open Filename:="c:\test.xls", UpdateLinks:=3

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]