Opening SharePoint file with VBA - disable SharePoint "Contacting the server" message

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.

Hi,

Try

Please Login or Register  to view this content.

http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

Hi,

If you need to press a key (like Enter) to continue from the message, you might be able to use a
Sendkeys command in Excel to put it in the keyboard buffer to get it to continue.
Otherwise, is there a parameter you can use in the Sharepoint open to not show messages? Perhaps a way to set the Sharepoint Open or Alert defaults? http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

mscurtin67,

This thread is 2 yrs old and the original poster is not likely to come back and respond. Its better if you post a new thread for your question. You will get better visibility and faster replies.