Set SharePoint People Picker from VBA Excel

Question

_{Thursday, February 9, 2017 12:00 AM}

Hi.

I am developing a macro where it is required to set a sharepoint person picker where the value is obtained from an excel cell, Is there any way to do it using vba excel?

Thanks u so much.

laureano Adriano

All replies (2)

_{Thursday, February 9, 2017 7:53 AM ✅Answered}

Hi laureano,

According to your description, you want to set a SharePoint person picker where the value is obtained from an excel cell using VBA and web service.

Import SharePoint 2010 list data from Excel table using VBA:

http://stackoverflow.com/questions/20116896/import-sharepoint-2010-list-data-from-excel-table-using-vba?rq=1

Add or Update single item in SharePoint list via VBA:

http://sharepoint.stackexchange.com/questions/93181/add-and-update-single-item-in-sharepoint-list-via-vba

Lists.UpdateListItems Method:

https://msdn.microsoft.com/en-us/library/lists.lists.updatelistitems(v=office.12).aspx

Best Regards,

Lisa Chen

Please remember to mark the replies as answers if they help.
If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com

---

_{Monday, February 13, 2017 11:50 PM}

Thank u so much it was just what I was looking for.

laureano Adriano