Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_open
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_open
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. -- Jim Rech Excel MVP "julio" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_open
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 -- regards, Tom Ogilvy "julio" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_open
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" wrote: 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 -- regards, Tom Ogilvy "julio" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
workbook_open
That is correct. This is not a workbook setting.
-- Regards, Tom Ogilvy "julio" wrote in message ... 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" wrote: 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 -- regards, Tom Ogilvy "julio" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Workbook_Open () | Excel Discussion (Misc queries) | |||
Workbook_Open | Excel Programming | |||
Help with Workbook_Open | Excel Programming | |||
Workbook_Open Event | Excel Programming | |||
Auto_Open Vs Workbook_open | Excel Programming |