Hi i want to import sharepoint list to excel then edit and then export bac to sharepoint.
i found this code for importing bud this code doesnt import multiple value fields (they just mising in table). Why? how to fix this?
Dim ws As Worksheet
Set ws = ThisWorkbook.Worksheets(1)
Dim src(1) As Variant
src(0) = "http://sharepoint.com/_vti_bin"
src(1) = "*-*-*-*-*"
ws.ListObjects.Add xlSrcExternal, src, True, xlYes, ws.Range("A1")