Excel VBA Automatically update links and data connections

[LEVICC01]

Hi,

Hopefully this is an easy one, but i cant get it to work unfortunately.

Every morning my computer opens a workbook, that triggers activity. This involves opening multiple other workbooks and copying information, etc to compile a report.

The final piece tot his automation requires links and data connections to be enabled, but i dont want it as a default setting, just for these specific workbooks.

So, is it possible when the code triggers the file to open, that i can ask it to autmatically enable links and data connections, if there are any.

if so, does anyone have the code?

Many Thanks

 

[Sektor]

Sub G()
    Workbooks.Open Filename:="C:\1.xlsx", UpdateLinks:=False
End Sub

 

[LEVICC01]

Perfect!

Thank you, if i had only thought to put a comma, i would have seen that.

Many thanks