Workbook Open with out update links

[paulcherianc]

How can I suppress the update link message while opening a workbook through the following code:

Dim wb1 As Excel.Workbook
Set wb1 = Workbooks.Open(Worksheets("Macro").Range("L13"))

 

[Hui]

Dim wb1 As Excel.Workbook
Set wb1 = Workbooks.Open(Worksheets("Macro").Range("L13")),  updatelinks:=0

I'm also wondering why you include the Range?
I suspect the code should be:

Dim wb1 As Excel.Workbook
Set wb1 = Workbooks.Open(Worksheets("Macro")),  updatelinks:=0

You should also have a read of:
https://stackoverflow.com/questions/14908372/how-to-suppress-update-links-warning

 

[paulcherianc]

Thanks, Hui. It worked. Well, I have added the range where I have the path to the folder. I need to change the path if needed. Thanks for your support!