activities
latest
false
重要 :
このコンテンツの一部は機械翻訳によって処理されており、完全な翻訳を保証するものではありません。 新しいコンテンツの翻訳は、およそ 1 ~ 2 週間で公開されます。
UiPath logo, featuring letters U and I in white

Productivity Activities

最終更新日時 2025年9月16日

Invoke VBA

UiPath.Excel.Activities.InvokeVBAX

Invokes a macro from an external file containing VBA code and runs it against an Excel file. This activity can run macros on any type of Excel file, such as .xls and .xlsx. Can only be used in the Excel Application Scope or Use Excel File activities.
Note: In order for this activity to work, Trust Access to the VBA project object model must be enabled from Excel (File > Options > Trust Center > Trust Center Settings > Macro Settings > Select the Trust Access to the VBA project object model check box).

Configuring the Activity

In the Body of the Activity
  • Target workbook - The workbook on which to execute the VBA function.
  • Code File Path - The path to the macro file which contains the VBA Sub/Function definitions. This field supports only strings or String variables. Use the Browse button to browse for files and select one.
  • Entry Method Name - The Sub/Function name that is to be invoked. Must be present in the macro file supplied in the Code File Path property.
  • Output to - Reference to the value returned by the execution of the invoked code, if any. This output is retrieved as Object variables.
  • Add VBA Argument - Adds an input argument to the VBA Sub/Function:

    • Argument value - The value to be passed to the input argument of the VBA Sub/Function.
Properties panel

Common

  • DisplayName - The display name of the activity.

Input

  • See the information in the Designer panel section.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output

  • See the information in the Designer panel section.
  • Configuring the Activity

このページは役に立ちましたか?

サポートを受ける
RPA について学ぶ - オートメーション コース
UiPath コミュニティ フォーラム
Uipath Logo
信頼とセキュリティ
© 2005-2025 UiPath. All rights reserved.