Skip to content
HOW TO

Control Another Workbook

Goal

Launch, monitor, or control another Excel workbook from a U workflow.

Prerequisites

  • The exact target workbook path and intended Excel process behavior.
  • Control explicitly enabled for the target workflow.
  • A recovery plan for a workbook that fails to open, calculate, save, or close.

Steps

1. Enable workbook control explicitly and verify the target workbook's state.

2. Launch or identify the target Excel process.

=U.LAUNCH_EXCEL(B10:B11)

3. Pass a visible settings table to U.CONTROL_EXCEL.

=U.CONTROL_EXCEL(B18:C29)

4. Keep save, close, kill, overwrite, and repeated actions behind block parameters or explicit trigger cells.

Result

The controller workbook can identify or launch the target, apply supported control settings, and expose status for monitoring.

Common Variations

  • Launch a new Excel process or control an existing enabled workbook.
  • Set values when opening a target workbook.
  • Monitor, back up, protect, or distribute a workbook through their dedicated functions.

Troubleshooting

  • If the target is not found, compare normalized workbook paths and process identifiers.
  • If control is refused, verify U.ENABLE_CONTROL and the current control settings.
  • Keep kill, overwrite, save, and close actions behind explicit triggers.