Workbook Open Vba Update Links. Have questions or feedback about Office VBA or this documentation? Name Required/Optional Data type Description; FileName: Optional: Variant: String.
In this article, we're going to show you how to make Excel update links automatically using VBA. You are most likely reading this article because you thought turning off ScreenUpdating and DisplayAlerts would prevent any and all message boxes from appearing while your VBA code runs. I tried doing it but it is not copying or updating the slave sheet.
In the Project window, find your project/workbook name and click the plus sign next to it in order to see all the sheets.
After opening the workbook, on the Data tab, in the Connections group, click Edit Links, and then update the links only from the sources that you need.
You are most likely reading this article because you thought turning off ScreenUpdating and DisplayAlerts would prevent any and all message boxes from appearing while your VBA code runs. Or you can enter Microsoft Visual Basic for Applications window via Developer->Visual Basic. Placing the macro here allows it to run each time the workbook opens.