Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.

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")
share|improve this question

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.