Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress Update Links dialog AND don't update links
Hi all
I have created an Excel utility that works on the other open workbooks. When other workbooks are opened, I want to suppress the Update Links dialog (using Application.AskToUpdateLinks = False) but I also DON'T want the links to be updated. Users will be on Excel 97. Any suggestions as to a VBA solution that I can put in the utility which will be open first? Thanks in advance Paul Martin Melbourne, Australia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress Update Links dialog AND don't update links
Drop the .asktoupdatelinks.
And change your code in your utility to open the file without updating links. You'll see an option on the workbooks.open statement that can be used to specify how links should be treated. See VBA's help for all the options. Paul Martin wrote: Hi all I have created an Excel utility that works on the other open workbooks. When other workbooks are opened, I want to suppress the Update Links dialog (using Application.AskToUpdateLinks = False) but I also DON'T want the links to be updated. Users will be on Excel 97. Any suggestions as to a VBA solution that I can put in the utility which will be open first? Thanks in advance Paul Martin Melbourne, Australia -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress Update Links dialog AND don't update links
Hi Dave
No, unfortunately users could be using any version from 97 to 2003, but mostly 97. Paul Dave Peterson wrote: If you're using xl2002+, you can use: edit|links|startup prompt (along with that application setting) to stop the update. Paul Martin wrote: Hi Dave The workbooks are being opened manually, and will not be opened programmatically. Paul Dave Peterson wrote: Drop the .asktoupdatelinks. And change your code in your utility to open the file without updating links. You'll see an option on the workbooks.open statement that can be used to specify how links should be treated. See VBA's help for all the options. Paul Martin wrote: Hi all I have created an Excel utility that works on the other open workbooks. When other workbooks are opened, I want to suppress the Update Links dialog (using Application.AskToUpdateLinks = False) but I also DON'T want the links to be updated. Users will be on Excel 97. Any suggestions as to a VBA solution that I can put in the utility which will be open first? Thanks in advance Paul Martin Melbourne, Australia -- Dave Peterson -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Suppress Update Links dialog AND don't update links
I'm out of ideas.
Paul Martin wrote: Hi Dave No, unfortunately users could be using any version from 97 to 2003, but mostly 97. Paul Dave Peterson wrote: If you're using xl2002+, you can use: edit|links|startup prompt (along with that application setting) to stop the update. Paul Martin wrote: Hi Dave The workbooks are being opened manually, and will not be opened programmatically. Paul Dave Peterson wrote: Drop the .asktoupdatelinks. And change your code in your utility to open the file without updating links. You'll see an option on the workbooks.open statement that can be used to specify how links should be treated. See VBA's help for all the options. Paul Martin wrote: Hi all I have created an Excel utility that works on the other open workbooks. When other workbooks are opened, I want to suppress the Update Links dialog (using Application.AskToUpdateLinks = False) but I also DON'T want the links to be updated. Users will be on Excel 97. Any suggestions as to a VBA solution that I can put in the utility which will be open first? Thanks in advance Paul Martin Melbourne, Australia -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Suppress Update Links Prompt | Excel Discussion (Misc queries) | |||
Disabling Update Links dialog box | Excel Discussion (Misc queries) | |||
Update links box gives Continue or Edit Links dialog | Excel Discussion (Misc queries) | |||
Suppress Update Links Message | Excel Discussion (Misc queries) | |||
Suppress Alerts - Update Links | Excel Programming |