+ Reply to Thread
Results 1 to 7 of 7

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

  1. #1
    Registered User
    Join Date
    09-23-2010
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    20

    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.
    Last edited by kopite2002; 02-04-2011 at 06:50 AM. Reason: Further detail

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,397

    Re: Opening workbook with VBA - how to stop this message though?

    Hi,

    Try

    Please Login or Register  to view this content.
    http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    09-23-2010
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Opening workbook with VBA - how to stop this message though?

    I've tried that and it doesn't work, it stops the "Do you want to save your changes?" message coming up when closing the workbook, but not the dialogue box to say it's opening the file.

  4. #4
    Registered User
    Join Date
    09-23-2010
    Location
    UK
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Opening SharePoint file with VBA - disable SharePoint "Contacting the server" mes

    Have now realised this is actually a SharePoint message, not an Excel message. Original post updated.

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    15,397

    Re: Opening SharePoint file with VBA - disable SharePoint "Contacting the server" mes

    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

  6. #6
    Registered User
    Join Date
    02-18-2013
    Location
    Boston, MA
    MS-Off Ver
    Excel 2010
    Posts
    4

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

    Were you able to resolve this issue. I have similar need. If yes, please post your full code.

  7. #7
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,160

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

    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.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1