Programming Excel with VBA and .NET

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
Filename	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