Name
workbooks
.CheckOut(Filename
)
Synopsis
For workbooks that are part of a shared workspace, checks out a workbook from the SharePoint server. Excel returns an error if the workbook could not be checked out, so use the CanCheckOut
method before calling CheckOut
.
Argument |
Settings |
---|---|
|
The address of the file on the SharePoint server to check out |
The CheckOut
method doesn’t open the file or download it from the SharePoint server. Use the Open
method to open the file after checking it out, as shown here:
fil = "//wombat1/Team Wombat/Shared Documents/blank.xls" If Application.Workbooks.CanCheckOut(fil) Then Application.Workbooks.CheckOut fil Application.Workbooks.Open fil End If
Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.