Hi,
I am looking to extract data from a SharePoint . I've got the following code so far but its giving me an error on the underline row as "Run time error 1004 : excel cannot connect to sharepoint list'. Any help?
Dim List As ListObject
Dim Wksheet As Worksheet
Const servStr As String =...