Report Builder 中的 Visual Basic 巨集

Last update: Fri Sep 01 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

主題：
Report Builder

建立對象：

User
Admin

Visual Basic (VBA)巨集提供的功能可協助您重新整理Excel活頁簿。 Visual Basic可以存取活頁簿、Excel和Windows。

您必須先執行最新版本的Report Builder並登入，才能執行VBA巨集。

IMPORTANT

基於安全理由，您無法排程包含巨集的活頁簿。

Adobe 支援三種 Report Builder API 方法。

`RefreshAllReportBuilderRequests()`

RefreshAllReportBuilderRequests() 巨集會重新整理作用中活頁簿裡所有的 Report Builder 請求。首先透過其產品 ID 呼叫 Report Builder COM 增益集，然後呼叫 RefreshAllRequests() API 命令：

Sub RefreshAllReportBuilderRequests()

 Dim addIn As COMAddIn
 Dim automationObject As Object
 Dim success As String
 Set addIn = Application.COMAddIns("ReportBuilderAddIn.Connect")
 Set automationObject = addIn.Object
 success = automationObject.RefreshAllRequests(ActiveWorkbook)

End Sub

`RefreshAllReportBuilderRequestsInActiveWorksheet()`

RefreshAllReportBuilderRequestsInActiveWorksheet() 巨集會重新整理作用中工作表裡所有的 Report Builder 請求。RefreshWorksheetRequests() API 呼叫會將工作表物件視為引數。您可以對任何包含 Report Builder 請求的任何工作表使用此呼叫：

Sub RefreshAllReportBuilderRequestsInActiveWorksheet()

 Dim addIn As COMAddIn
 Dim automationObject As Object
 Dim success As String
 Set addIn = Application.COMAddIns("ReportBuilderAddIn.Connect")
 Set automationObject = addIn.Object
 success = automationObject.RefreshWorksheetRequests(ActiveWorkbook.ActiveSheet)

End Sub

`RefreshAllReportBuilderRequestsInCellsRange()`

RefreshAllReportBuilderRequestsInCellsRange() 巨集會重新整理儲存格輸出與指定儲存格範圍相交的所有 Report Builder 請求。此範例中使用的儲存格範圍，指向作用中活頁簿內「資料」工作表的 B1:B54 範圍。範圍運算式支援所有支援的 Excel 範圍運算式：

Sub RefreshAllReportBuilderRequestsInCellsRange()

 Dim addIn As COMAddIn
 Dim automationObject As Object
 Dim success As String
 Set addIn = Application.COMAddIns("ReportBuilderAddIn.Connect")
 Set automationObject = addIn.Object
 success = automationObject.RefreshRequestsInCellsRange("'Data'!B1:B54")

End Sub

recommendation-more-help

a83f8947-1ec6-4156-b2fc-94b5551b3efc