Hi,

I hope this is the right forum. I can get a file to save to SharePoint through VBA, that much I have figured out. Where I am struggling is how to take information from a cell and post it in column I have created in the document library for metadata. example: I have the dept that the file is for stored in a cell on sheet 1, how do I get that to populate the column in SharePoint (a choice column) from that cell when the file is added? Any thoughts would be appreciated.

Thanks in advance for the many brilliant minds that have either done this already or can come up with a solution!
Have a great day!