_Workbook.CheckInWithVersion Method
Saves a workbook to a server from a local computer, and sets the local workbook to read-only so that it cannot be edited locally.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub CheckInWithVersion ( _
SaveChanges As Object, _
Comments As Object, _
MakePublic As Object, _
VersionType As Object _
)
'Usage
Dim instance As _Workbook
Dim SaveChanges As Object
Dim Comments As Object
Dim MakePublic As Object
Dim VersionType As Object
instance.CheckInWithVersion(SaveChanges, _
Comments, MakePublic, VersionType)
void CheckInWithVersion(
Object SaveChanges,
Object Comments,
Object MakePublic,
Object VersionType
)
Parameters
SaveChanges
Type: System.Objecttrue to save the workbook to the server location. The default is true.
Comments
Type: System.ObjectComments for the revision of the workbook being checked in (applies only if SaveChanges is set to true).
MakePublic
Type: System.Objecttrue to allow the user to publish the workbook after it is checked in.
VersionType
Type: System.ObjectSpecifies versioning information for the workbook.
Remarks
Setting the MakePublic parameter to true submits the workbook for the approval process, which can eventually result in a version of the workbook being published to users with read-only rights to the workbook (applies only if SaveChanges is set to true).
To take advantage of the collaboration features built into Microsoft Excel, documents must be stored on a Microsoft SharePoint Server.