Forum Discussion
Insert SharePoint Doc ID in Excel Footer
Hi there, I am creating a document management system in SharePoint with automatic numbering and version control. This is working perfectly for word documents. When I upload the Excel file the automa...
Did you ever get this figured out? I am trying to do the same thing, and not getting very far.
Thanks!
To pickup properties we need VBA, to insert formula into the header or footer - also with VBA. Thus it shall be macro-enabled file. Which will work only in desktop app.
I am fine with using the desktop application if it allows me to get the Sharepoint document ID, and version number into the spreadsheet somewhere.
Are there any sites where I might find the code to do this, so that I can grab it and make small changes so it will fit my specific needs? I'm a networking guy, not a developer, so this is a little outside of my comfort zone.
Thanks!