Open an excel file in Sharepoint file list with VBA code


  • Hello all,

    I got a little problem when I try to check out a excel file in the sharepoint file list with vba code,

    When I use the code:


    Actually the excel file can be checked out but just after that  the file showed up and closed. I got no idea how this is from. Could any body help with it?

    Thanks and best wishes

    Friday, July 16, 2010 9:35 AM

All replies

  • A couple of questions:

    1. From what application are you running the VBA code?

    2. Does this happen with any Office file you test or just an Excel file? If it's just an Excel file, is it only this one file that you are having trouble with or does the same happen with all Excel files?

    Will Buffington
    Microsoft Excel Support

    Monday, July 19, 2010 11:43 PM
  • Thanks for your reply,

    Actually this happens for all the excel files that saved in sharepoint. The VBA code is in a excel file.

    Best wishes  


    Monday, August 16, 2010 12:39 PM