VBA Help

  • Thread starter Thread starter Roger R
  • Start date Start date
R

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
 
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
 
Roger

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

See also help on update links properties.

Gord Dibben Excel MVP
 
This almost does the trick, the problem is that it DOES
update the link and I DO NOT want the links updated.
 
Back
Top