Results 1 to 2 of 2

Thread: Sharepoint Check out & Check in

  1. #1

    Sharepoint Check out & Check in

    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Folks

    I have another problem! WizardofOz kindly pointed me in the direction of the Microsoft pages for assistance with Check out & Check in documents via VBA.

    After some investigating and general searching I have managed to nearly get what I need but need asistance with the following

    Please could someone advise how to change the following to apply to a number of other excel files on Sharepoint at the same time? i.e check out the file mentioned plus others named "Planning Team" for example

    Sub test()
    Dim docCheckOut As String
    docCheckOut = " Team.xls"
    Call UseCheckOut(docCheckOut)
    End Sub
    Sub UseCheckOut(docCheckOut As String)
    ' Determine if workbook can be checked out.
    If Workbooks.CanCheckOut(docCheckOut) = True Then
    Workbooks.CheckOut docCheckOut
    MsgBox "Unable to check out this document at this time."
    End If
    End Sub

    You've probably guessed the next question! What would the code be to then do the opposite i.e Check all the files back in (preferably bypassing the "do you need to add comments" pop up)

    Many thanks as always!


  2. #2


    Can anyone help please?

Posting Permissions

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