sharepoint online – Getting version number into the spreadsheet


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?

Thanks