VBA solution to get rid of "update" links message when a file is opened?

[Mr2017]

Hi

I get two different types of messages when opening certain files with a macro, that I don't want to get.

One of them says

"This workbook contains links to one or more sources that could be unsafe.

If you trust the links, update them, to get the latest data...."

Then it gives you buttons that say "Update," "Don't update," and "Help."

I'd like the macro to either remove this message from appearing or click on "Don't update."

Does anyone know what the code is?

TIA

 

[Paul Ked]

A quick Google revealed lots of 'solutions' depending on Excel version and how you are opening the file.

https://www.mrexcel.com/forum/excel...s-one-more-external-sources-could-unsafe.html

https://stackoverflow.com/questions/14908372/how-to-suppress-update-links-warning

 

[Mr2017]

Hi Paul

Thanks for the response.

Do you know where I should put that code to make it work?

I've tried to put it in the code below, but it hasn't worked, as expected.

It's commented out, at the moment (there's an apostrophe before it):

Sub OpenFile(file_name)
 
Application.ScreenUpdating = False
 
This_Bk = ActiveWorkbook.Name
Application.EnableEvents = False
Workbooks.Open (file_name)
NewFile = ActiveWorkbook.Name
 
Application.EnableEvents = True
'Application.Workbooks.Open FileName:="NewFile", UpdateLinks:=False
Workbooks(NewFile).Activate
Worksheets("Sheet1").Select

 

[Paul Ked]

Sorry for delay, been working!

That code doesn't make sense. It opens a file 'file_name', which has been passed to the sub then gives 'NewFile' the same name and tries to open it again!

Do you mean:

Sub OpenFile(file_name)
    Application.ScreenUpdating = False 
    Application.EnableEvents = False
    Workbooks.Open (file_name), UpdateLinks:=False
    Worksheets(1).Select
    Application.EnableEvents = True
End Sub

If I had an idea of what you are trying to achieve then maybe I, or someone else, could give you the correct answer.

 

[Mr2017]

Excellent! Thank you Paul Ked !

Yes - that's what I was trying to do!

I didn't know that you could just add the "UpdateLinks:=False" code after opening the file and separating the code with a comma!

This is really useful!

Thanks ever so much!!

 

[Paul Ked]

Glad to be of service