Disable "contacting the server for information" message?

S

SixSigmaGuy

Is there a way I can prevent the "Contacting the server for information"
message from appearing when I am programmatically opening Excel files stored
on a SharePoint Server? I'm opening lots of files in my code and the
message appears almost every time. The message is a real nuisance because
it comes up while I'm typing in another application, e.g., I'm writing an
email, and my keystrokes go to the "contacting the server for information"
message instead.
 
A

Alan

Unless

Application.ScreenUpdating = False

and/or

Application.DisplayAlerts = False

represses it, I doubt it. I guess I will be dealing with this soon. We are
moving to SharePoint next quarter.

Alan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top