Open workbook without update all linked information
 

I am writing a macro which opens and closes a series of workbooks. One of
the workbooks contains formula that have links to other workbooks. So, the
macro stops when it tries to open this workbook and ask if I want to update
all linked information.

Is there a code that specifically tells Excel to open workbooks and if it
contains links, do not update all the linked information?

I think this works:
Application.DisplayAlerts = False
But this one surpresses all alerts.

Thanks in advance

Warren

Open workbook without update all linked information
 

I don't believe displayalerts works in this case. What does work is the
second argument to the workbooks.open method

workbooks.open filename:="Whatever", UpdateLinks:=0

--
Regards,
Tom Ogilvy


Warren wrote in message
news:DDBUb.233910$na.375229@attbi_s04...
I am writing a macro which opens and closes a series of workbooks. One of
the workbooks contains formula that have links to other workbooks. So,
the
macro stops when it tries to open this workbook and ask if I want to
update
all linked information.

Is there a code that specifically tells Excel to open workbooks and if it
contains links, do not update all the linked information?

I think this works:
Application.DisplayAlerts = False
But this one surpresses all alerts.

Thanks in advance

Warren

Open workbook without update all linked information
 

Thanks Tom.

....and you are right, DisplayAlert does not work...

Regards,
Warren
Tom Ogilvy wrote in message
...
I don't believe displayalerts works in this case. What does work is the
second argument to the workbooks.open method

workbooks.open filename:="Whatever", UpdateLinks:=0

--
Regards,
Tom Ogilvy


Warren wrote in message
news:DDBUb.233910$na.375229@attbi_s04...
I am writing a macro which opens and closes a series of workbooks. One
of
the workbooks contains formula that have links to other workbooks. So,
the
macro stops when it tries to open this workbook and ask if I want to
update
all linked information.

Is there a code that specifically tells Excel to open workbooks and if
it
contains links, do not update all the linked information?

I think this works:
Application.DisplayAlerts = False
But this one surpresses all alerts.

Thanks in advance

Warren