Forum Discussion
Niklas_E
Apr 17, 2023Copper Contributor
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
3 Replies
Sort By
- 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- m_booth1981Copper Contributor
Do you have any instructions on how to do this please I am really struggling to do it.
Many thanks
Mark
- Niklas_ECopper ContributorExcellent, thanks! It worked perfectly 🙂