Forum Discussion
Solved
How do I get the SharePoint document Version number into an Excel file
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.
- 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
- 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.CustomDocumentPropertiesDo you have any instructions on how to do this please I am really struggling to do it.
Many thanks
Mark
- Excellent, thanks! It worked perfectly 🙂
