Home ListObject connected to a SharePoint list with a column filled with a multiple lookup
Reply: 0

ListObject connected to a SharePoint list with a column filled with a multiple lookup

user838
1#
user838 Published in June 19, 2018, 4:29 pm

I'm using ListObject in Excel's VBA to get a list from SharePoint so I'm able to view it in Excel and add new items from Excel. The only problem is that the SharePoint List has a column which accepts multiple lookup values connected to another SharePoint List. This column is not shown in Excel when I run the VBA code.

Sub PublishList()

Dim objList As ListObject
Dim strSPServer As String
Const SERVER As String = "https://<SharepointUrl>"
Const LISTNAME As String = "ListName"
Const VIEWNAME As String = ""

strSPServer = SERVER & "_vti_bin"

Set objWs = ActiveSheet

Set objList = objWs.ListObjects.Add(xlSrcExternal, Array(strSPServer, LISTNAME, VIEWNAME), True, xlYes, Range("A1"))

Set objList = Nothing
Set objWs = Nothing

End Sub

Is there a solution to this problem?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.255968 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO