Change Value in Relate People Property

[mard3010]

Good afternoon,

I have a document that has some custom properties taken from share point, and when I check the file/info/properties they are in the "Related People" category.

Is there a way I can change the "EmailUsers" property from VBA (this property comes from a Document library column field in Sharepoint)? I have tried with this but it gives me error and I have spent two days trying to find out how can I do it

ActiveWorkbook.BuiltinDocumentProperties("EmailUsers").Value =email

also tried

ActiveWorkbook.CustomDocumentProperties("EmailUsers").Value =email

and

ActiveWorkbook.ContentTypeProperties("EmailUsers").Value =email


Any help would be appreciate.

Thanks

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Change Value in Relate People Property
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[mard3010]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Change Value in Relate People Property
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Sorry I did not know it was the same page. Thanks. I will have that in mind next time.

 

[Joe4]

Sorry I did not know it was the same page.

Its not the same. The issue is with posting the same question on multiple forums, if not done properly.
Read this link for a complete explanation of the issue: Excelguru Help Site - A message to forum cross posters