CODEWITHSUNDEEP
excelsharepointvba
L.Horvath
L.Horvath

Reputation: 55

Edit sharepoint list with macro

I need to change the status and write comments for about 100 lists in SharePoint every week. I tried to automate it. I know how to open them in edit mode with a macro, but I don't know how to change status or how to write a comment with a macro, any ideas?

Here is my code: 

Sub TT()
  Dim ie(40) As Object, obj As Object
  Dim cislo As String
  For i = 0 To 40
    If Cells(i + 2, 1).Value = "" Then
      Exit Sub
    End If
    Set ie(i) = CreateObject("Internetexplorer.Application")
    ie(i).Visible = True
    ie(i).Navigate "http://adress of sharepoint list .com"
    Do While ie(i).Busy
    Loop
  Next i
End Sub

Upvotes: 4

Views: 2197

Answers (1)

MattE
MattE

Reputation: 1114

These tutorials should give you what you need to know...excellent and well done, they show you how to do it via Listobjects and via SQL

https://www.youtube.com/watch?v=nM-gq3N6f2E

There is a series of 13 videos.

Upvotes: 3

Related Questions