Skip to main content

worksheet : MACRO_RUN_APPLICATION

Overview​

This video demonstrates the MACRO_RUN_APPLICATION worksheet command in Nitro-CELL, which runs an Excel VBA macro at the application level from within a Nitro-CELL automation workflow. This allows engineers to integrate custom Excel macros into their Creo automation sequences, extending Nitro-CELL's capabilities with custom VBA logic for data processing, formatting, or external system integration. The macro runs in the Excel application context, giving it access to all open workbooks and application-level objects. The video covers specifying the macro name, executing the command, and verifying the macro ran successfully.

Key Steps​

  1. Ensure the target VBA macro is available in the Excel environment
  2. Enter the MACRO_RUN_APPLICATION command with the macro name
  3. Execute the command to run the macro at the application 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 accessible in the current Excel session (personal macros or workbook macros)
  • Application-level macros can access all open workbooks and Excel objects
  • Use for custom data processing steps between Nitro-CELL commands