How do I get the SharePoint document Version number into an Excel file

[Niklas_E]

As the subject states, I am looking for a way to insert the current document version into the actual Excel file itself.

I have content management/versioning enabled so that is up and running.

Example:

I would like to have the "2.0" in the actual TEST.xlsm somehow.

[#2 · Accepted solution]

So in Excel there isn't a quick part as same as in Word but you can create a function in Excel that get's the Custom SharePoint value

https://learn.microsoft.com/en-us/office/vba/api/Excel.Workbook.CustomDocumentProperties

[#3]

Excellent, thanks! It worked perfectly 🙂

[#4]

@NicolasKheirallah 

Do you have any instructions on how to do this please I am really struggling to do it. 

Many thanks 

Mark