Forum Discussion

Copper Contributor

Feb 01, 2018

How to update a multi-choice field of a sharepoint list with ADO

Dear Community, I managed to create a VBscript to access a Sharepoint-List, get a recordset, add a line and fields etc. with ADO. One thing that I can't get to work is how to set or update a mu...

bdorman

Copper Contributor

Jun 26, 2025

Hi Martijn,

I'm working on a VBS script that will pull data from a SharePoint list, compare that data with another list extracted from SAP GUI, then update the SharePoint list. I don't have much coding experience, and this is the first time I have used VBS scripting. Can you provide any templates or information that will help me out. I have been able to extract the data from SAP GUI a put that into a .txt file but I have been unable to make a connection or get any data from the SharePoint list.

Thanks

Martijn Crabbendam

Copper Contributor

Jun 27, 2025

Hi bdorman,

You reply to a very old post of mine, I haven't done much vbscripting lately, especially not to read or update sharepoint lists. I did the scripting most of times from excel, it may be that it makes it easier as a lot of connections are already provided with the office environment.

I did spend a few moments to dig in my archive but my bits of code are too large / need too much explanation to share and they may not even work directly since sharepoint moved to sharepoint-online etc.

That was all I have time for, good luck with your project!

Kind regards,

Martijn.