Set Sharepoint Document property via VB

**Yoam69** · 04-26-2011, 05:37 PM

Is there a way to set a document property for a file that is stored on a sharepoint server using VB code? I can set it manually, but can't find (or record) the code to do it.

Manual steps are: Office Button-Prepare-Document Properties
The column I created on Sharepoint shows up under "Document Properties - Server"

I want to set the value of this field programatically.

**Pindacko** · 09-14-2012, 12:55 PM

Yoam69
Did you get a Answer? I am tring to do the same thing.

**Yoam69** · 09-14-2012, 01:33 PM

Yes, I did. Here a bit of code I used that did the trick:

Please Login or Register  to view this content.

The key is the collection called ContentTypeProperties. The names of those properties correspond to the names
listed in the properties of your sharepoint document. In my case, the ones I'm setting are "Brand", "Description", "Complete Date", "Assigned To" and "Eng Comp Date". I'm setting them to the value of a range in my workbook, but you could just as easily set them to the value of a variable in your code or a hard coded string.

Hope this help...I've gotten a lot of mileage out of the technique.