SharePoint

XlCheckInVersionTypeSpecifies the type of version for the document checked in when using the CheckIn method.
xlListDataTypeSpecifies the data type of a list column connected to a Microsoft Windows SharePoint Services site.
XlCheckInVersionType
Specifies the type of version for the document checked in when using the CheckIn method.
xlListDataType
Specifies the data type of a list column connected to a Microsoft Windows SharePoint Services site.

xlCheckInVersionType

Specifies the type of version for the document checked in when using the CheckIn method.

xlCheckInMajorVersionCheck in the major version (1)
xlCheckInMinorVersionCheck in the minor version (0)
xlCheckInOverwriteVersionOverwrite current version on the server (2)

xlCheckInMajorVersion
Check in the major version (1)
xlCheckInMinorVersion
Check in the minor version (0)
xlCheckInOverwriteVersion
Overwrite current version on the server (2)

REMARKS
* Added in 2007.
* Applies to workbooks stored in a SharePoint library.

xlListDataType

Specifies the data type of a list column connected to a Microsoft Windows SharePoint Services site.

xlListDataTypeCheckboxCheckbox (9)
xlListDataTypeChoiceChoice (6)
xlListDataTypeChoiceMultiChoice Multi (7)
xlListDataTypeCounterCounter (11)
xlListDataTypeCurrencyCurrency (4)
xlListDataTypeDateTimeDateTime (5)
xlListDataTypeHyperLinkHyperlink (10)
xlListDataTypeListLookupList Lookup (8)
xlListDataTypeMultiLineRichTextMulti-line Rich Text (12)
xlListDataTypeMultiLineTextMulti-line Text (2)
xlListDataTypeNoneNone (0)
xlListDataTypeNumberNumber (3)
xlListDataTypeTextText (1)

xlListDataTypeCheckbox
Checkbox (9)
xlListDataTypeChoice
Choice (6)
xlListDataTypeChoiceMulti
Choice Multi (7)
xlListDataTypeCounter
Counter (11)
xlListDataTypeCurrency
Currency (4)
xlListDataTypeDateTime
DateTime (5)
xlListDataTypeHyperLink
Hyperlink (10)
xlListDataTypeListLookup
List Lookup (8)
xlListDataTypeMultiLineRichText
Multi-line Rich Text (12)
xlListDataTypeMultiLineText
Multi-line Text (2)
xlListDataTypeNone
None (0)
xlListDataTypeNumber
Number (3)
xlListDataTypeText
Text (1)


© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited Top