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. Examp...
- 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.CustomDocumentProperties
https://learn.microsoft.com/en-us/office/vba/api/Excel.Workbook.CustomDocumentProperties
Do 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 🙂
