Soshi
03-30-2021, 01:06 AM
Hello there o/
I am struggling to find a good solution for the macro mentioned above.
I have to open over 100 Excel Sheets, updatelinks and save them.
Once they are all done every excel-sheet, besides the mastersheet, should be closed.
I have the following for the first 2 steps.
Sub UpdateLinks()
Application.ScreenUpdating = False
Workbooks.Open "N:\###\Test001.xlsx", UpdateLinks:=1
[...]
Application.ScreenUpdating = True
End Sub
I am very rusty when it comes to vba and would appreciate your help!
Happy Easter
~Soshi
I am struggling to find a good solution for the macro mentioned above.
I have to open over 100 Excel Sheets, updatelinks and save them.
Once they are all done every excel-sheet, besides the mastersheet, should be closed.
I have the following for the first 2 steps.
Sub UpdateLinks()
Application.ScreenUpdating = False
Workbooks.Open "N:\###\Test001.xlsx", UpdateLinks:=1
[...]
Application.ScreenUpdating = True
End Sub
I am very rusty when it comes to vba and would appreciate your help!
Happy Easter
~Soshi