MS Excel - 现有连接字符串对应于哪个数据表

2 回答

• 3

  可以使用“数据”选项卡 .

  试试这个：

  • 单击 Data 选项卡中的 Connections 以显示 Workbook Connections 对话框 .

  

  • 单击列表中的连接 .

  

  • 点击链接： click here to see where the selected connections are used

  

  回复于 2024-05-10T20:24:49+08:00
• 0

  这也可以从VBA获得 . 此查询只是枚举它们 .

  您可以使用 PivotCache.Refresh 或 QueryTable.Refresh 轻松修改此示例以刷新查询 .

  Sub ShowAllQueryConnectionStrings()
      Dim oSheet As Excel.Worksheet
      For Each oSheet In Application.ActiveWorkbook.Sheets
          Dim oTable As Excel.QueryTable
          For Each oTable In oSheet.QueryTables
              Debug.Print "QueryTable " & oTable.Name & ": " & oTable.Connection
          Next
          Dim oPivot As Excel.PivotTable
          For Each oPivot In oSheet.PivotTables
              Debug.Print "PivotTable " & oPivot.Name & ": " & oPivot.PivotCache.Connection
          Next
      Next
  End Sub
  

  回复于 2024-05-10T20:24:49+08:00