excel - 从 Sharepoint 打开工作簿并从中获取工作表/数组

Question

我正在尝试从位于 Sharepoint 的工作簿中的工作表中获取数组。

Public Sub PushintoDB()
    Dim requestID As String
    Dim version As String
    Dim mapping As ListObject
    Dim source As Worksheet
    Dim dest As Workbook
    Dim weekly As Workbook
    Dim bidDB As ListObject
    Dim bidID As String
    Dim followup As ListObject
    Dim SummaryWB As Workbook
    Dim map As ListObject
    Application.DisplayAlerts = False
    Set weekly = Workbooks.Open("URL", 0, ReadOnly:=True)
   'Set source = ThisWorkbook.Sheets("Options")
   'Set dest = Workbooks.Open("URL",0,ReadOnly:=True)
    Set mapping = weekly.Worksheets("Mapping").ListObjects("Mapping")
    Set followup = weekly.Worksheets("follow-up").ListObjects("followup")
   'Set bidDB = dest.Worksheets("Bid-DB").ListObjects("BidDB")

URL 正确，工作表和数组的名称也正确，但映射没有获得每周参考。相反，它给了我错误

未设置对象变量或 With 块变量

它也不适用dest于正确的 URL，但它确实适用于source，这是代码所在的工作簿。

如何从 Sharepoint 位置打开和使用工作簿？

标签： excelvba