Hello Experts, I've developed some code that generates a set of workbooks for gathering information from my users. I've looking for a piece of code that will:
A) publish each workbook to a SharePoint document library
B) update some custom fields that have been added to my document library (Sector, Approver, Validate (Y/N)).
My code is currently set up to iterate through each workbook (i.e., creates, saves, and closes one WB at a time). The code should also be set up to allow me to re-publish and overwrite any existing file with the same name.