View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Basta1980 Basta1980 is offline
external usenet poster
 
Posts: 102
Default Set objListObject

Hi all,

Rather frustrated here ;-)

Trying to import a list from Sharepoint but I can't get the syntax right.

Sharpoint Site =
https://sharepoint.mycompany.com/com...Allitemsg.aspx
List = Overzicht Online diensten
Command = Set objListObject =
ActiveWorkbook.Worksheets(1).ListObjects.Add(Sourc eType:= xlSrcExternal, _
Source:= Array(strServerName, StrListGUID), TRUE, XlGuess,
Destination:= Range("A1")

How do I adress the source?

Kind regards

Basta1980