Updatelinks≔1, automatically continue if errors in links

[chris_rogers]

Hello All:

On a daily basis, we use a macro to open several spreadsheets that need to have their links updated, but always get the annoying question:

‘this workbook contains …. Cannot be updated’
‘Continue’ or ‘ Edit Links’

I'd like it to auto select Continue so I don’t have to sit around and click the button 20 times.

Things like:
Application.AskToUpdateLinks = False
Open… updatelinks≔1 ‘(or 3)
Application.AskToUpdateLinks = True
Do nothing.

My friend posted this question and was told to ‘read Microsoft help’… I don’t need to tell you how useless this is. Thanks moderator ‘shg’, you made the wall of shame.
Please respond with either the code or a link to the solution.

Thanks!

[romperstomper]

Might I suggest that you alter your tone if you wish people to assist you? Starting out with an aggressive/sarcastic post will not make people more likely to answer you.

[chris_rogers]

Now, here is the problem. From the forum, it looks like someone has replied with the solution, when it is instead nothing of any value.

Please respond with either the code or a link to the solution.

thanks all!

[romperstomper]

Yes, that must be the reason for the lack of answers.

[chris_rogers]

another great reply. its a simple request... Please respond with either the code or a link to the solution.

[romperstomper]

You do not seem to appreciate that I am trying to help you. Had you changed your tone, you would have had an answer by now. As it is, you are skating on thin ice.

[chris_rogers]

Nevermind.

I got the answer from another forum.

Application.DisplayAlerts = False
code
Application.DisplayAlerts = True

Moderators. The above is a helpful posting. Please learn from it.

[romperstomper]

There are none so blind as those who will not see.

[chris_rogers]

Better to keep your mouth shut and appear stupid than to open it and remove all doubt. ~Mark Twain

[romperstomper]

Isn't it ironic?
Alanis Morrissette

[shg]

My friend posted this question and was told to ‘read Microsoft help’… I don’t need to tell you how useless this is. Thanks moderator ‘shg’, you made the wall of shame.

I actually told her where to look and what to look for, but she couldn't be bothered.

Que sera.