Forum Discussion

Martijn Crabbendam's avatar
Martijn Crabbendam
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...
jcgonzalezmartin's avatar
jcgonzalezmartin
MVP
Feb 01, 2018
Why are you using VBScript to access the SharePoint list data?
Martijn Crabbendam's avatar
Martijn Crabbendam
Copper Contributor
Feb 01, 2018

Hi Juan,

 

I use vbscript a lot at Excel, Word, Outlook etc. I have some large script in excel to produce reports. I'd like to have the reports settings on sharepoint. 

 

 

  • johnweathington's avatar
    johnweathington
    Copper Contributor
    Feb 12, 2019

    Hi Martijn, did you ever find a solution to this? I am facing the exact same problem. Any help would be greatly appreciated.

    • Martijn Crabbendam's avatar
      Martijn Crabbendam
      Copper Contributor
      Feb 12, 2019

      Hi johnweathington John,

       

      In short, no. Funny is that I went for other solutions in the mean time and am just picking up yesterday to use sharepoint lists again. Main reason is that SharePoint is available to me and a proper (SQL) database is not :-). For now I just avoid multi-choice fields and use text fields in stead and let the script do the logic. I forgot about this post to be honest but will update when I find a solution, will you too?

       

      Kind regards,

      Martijn.

      • bdorman's avatar
        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

Resources