I have a spreadsheet on a spreadsheet located in a SharePoint library. Major and minor versions are enabled. I am trying to get names and values of some columns (metadata/properties) into the spreadsheet and have been largely successful in doing so by using ThisWorkbook.ContentTypeProperties in a VBA module.

However, I am unable to get the version number of the document. Does anyone know how this can be achieved?


1 Answer 1


We can get the file versions using File.Versions property.

The articles below for your reference:

Retrieve File Version Properties And Version Author Details On SharePoint Using CSOM PowerShell

How to Get the File Versions in SharePoint 2013 Online Using REST API

  • Thanks @LZ-WX How exactly do I use these in VBA?
    – KMLN
    Feb 2, 2018 at 15:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.