Skip to main content

worksheet : MACRO_RUN_WORKBOOK

Overview​

This video demonstrates the MACRO_RUN_WORKBOOK worksheet command in Nitro-CELL, which runs an Excel VBA macro at the workbook level from within a Nitro-CELL automation workflow. Unlike MACRO_RUN_APPLICATION which operates at the Excel application scope, this command runs the macro in the context of the current workbook, limiting its scope to the active workbook's sheets and objects. This is useful for running workbook-specific macros that process data, format results, or perform calculations as part of an automation sequence. The video shows how to specify the macro, execute it, and verify the results.

Key Steps​

  1. Ensure the VBA macro exists in the current workbook's macro modules
  2. Enter the MACRO_RUN_WORKBOOK command with the macro name
  3. Execute the command to run the macro at the workbook level
  4. Verify the macro executed successfully by checking its effects
  5. Continue with subsequent Nitro-CELL commands after the macro completes

Tips​

  • The macro must be defined in the current workbook, not in personal macros
  • Workbook-level scope limits the macro to the active workbook's objects
  • Use for workbook-specific data processing between Nitro-CELL commands