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.

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




"SixSigmaGuy" wrote:

> 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.
>
>
>