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.

Resources