I created a tool in Excel VBA that generates a custom report from the data I pulled from a SharePoint list via Excel VBA code.
What I want to do is change/update the "Status" field for items within the SharePoint list used above.
I read here that it's possible, but I didn't understand it very well.
The code I'm using to pull data form SharePoint:
Dim GUID As String, LISTNAME As String, URLNAME As String 'pull values from .iqy file (sharepoint export) GUID = unique id list LISTNAME = unique id for list name URLNAME = "url pulled from 'connection tab'" 'insert Sharepoint List here ActiveSheet.ListObjects.Add SourceType:=xlSrcExternal, _ Source:=Array(URLNAME, LISTNAME, GUID), LinkSource:=True, Destination:=Range("A1") With ActiveSheet .Range("A1").ListObject.Name = "DataTable" End With ActiveSheet.ListObjects("DataTable").Unlink
Thanks in advance.