I've got a macro that opens files on SharePoint and copies data across to a master spreadsheet. When it's opening the files (using Workbooks.Open command) SharePoint shows a message box saying that it's contacting the server to open the file (the files are quite large so it takes a few second to open them). Is there anything I can do to stop these messages showing? I've tried using the Application.DisplayAlerts = False command but this doesn't work, presumably because that only stops Excel's alerts.
Bookmarks