Workbook.CanCheckIn method (Excel)
True if Microsoft Excel can check in a specified workbook to a server. Read/write Boolean.
expression A variable that represents a Workbook object.
This example checks the server to see if the specified workbook can be checked in. If it can be, it saves and closes the workbook and checks it back into the server.
Sub CheckInOut(strWkbCheckIn As String) ' Determine if workbook can be checked in. If Workbooks(strWkbCheckIn).CanCheckIn = True Then Workbooks(strWkbCheckIn).CheckIn MsgBox strWkbCheckIn & " has been checked in." Else MsgBox "This file cannot be checked in " & _ "at this time. Please try again later." End If End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.