workbook_open

[Guest]

I have an add-in linked to a template, based on which a file is created. When
the user opens this file, he is prompted about updating links.

To avoid it, I tried

sub Workbook_Open()
..........
ActiveWorkbook.UpdateLinks = xlUpdateLinksNever
........

which doesn't work, because the message pops up before _open is run. How do
I get this to work ???

Thanks

 

[Jim Rech]

I assume you have Excel 2002 or 2003 because the UpdateLinks method is only
available in them. First you can get rid of that code you've written since
it closes the barn door after the horses have left.. Then (with the
workbook active) go into Edit, Links and click Startup Prompt and pick the
action you want.

 

[Tom Ogilvy]

the prompt to update links is fired before any code runs.

You can have the links updated without prompt by going into tools=>Options
and on the edit tab, uncheck ask to update automatic links.

In xl2002 and later, you have an option to disable the prompt and not update
under Edit=>Links.

In versions earlier than xl2002, there is no option to not update automatic
links and not prompt. You would need to open a 2nd workbook which uses code
to open the workbook with links using

Workbooks.Open "NameofWorkbookwithLinks.xls", updateLinks:=0

 

[Guest]

This is not really what i'm asking. I don't want the user to modify the
behavior of excel each time a new file is created, but rather, the fact that
a file is opened based on the template would programatically determine the
modified behavior. Note that the "LinKs" menu is accessible only after links
are created, so (unless i'm missing something) i can't save the *.xlt file
with "dont update" option active.
thnx
Julio

 

[Tom Ogilvy]

That is correct. This is not a workbook setting.