As per documentation, a
ListObject.Add
function requires to define a sheet in which the list is added.
For example:
Set objListObject = ActiveWorkbook.Worksheets(1).ListObjects.Add(SourceType:= xlSrcExternal, _
Source:= Array(strServerName, strListName, strListGUID), LinkSource:=True, _
XlListObjectHasHeaders:=xlGuess, Destination:=Range("A1")),
TableStyleName:=xlGuess, Destination:=Range("A10"))
See:
VBA -
ListObjects.Add method (Excel) | Microsoft Docs[
^]
VSTO -
How to: Add ListObject controls to worksheets - Visual Studio (Windows) | Microsoft Docs[
^]