VBA Help

[Roger R]

I'm trying to write a macro that opens a file that is
linked to another file. The sticking point is the dialog
box asking me if I would like to update the link or not.
I would not like to update the link. I can't figuer out
what to write to make that statment stop coming up. HELP!!

Roger

 

[Don Guillett]

from HELP
AskToUpdateLinks Property
See Also Applies To Example Specifics
True if Microsoft Excel asks the user to update links when opening files
with links. False if links are automatically updated with no dialog box.
Read/write Boolean.

Example
This example sets Microsoft Excel to ask the user to update links whenever a
file that contains links is opened.

Application.AskToUpdateLinks = True

 

[Gord Dibben]

Roger

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

See also help on update links properties.

Gord Dibben Excel MVP

 

[Roger R]

This almost does the trick, the problem is that it DOES
update the link and I DO NOT want the links updated.