Skip to content
EXAMPLE

Remote Controlled Workbook

Summary

Launch target workbooks in separate Excel processes and apply visible control settings from a controller workbook.

Files Used in This Example

Prerequisites

  • Exact target workbook names or paths.
  • Permission to launch Excel processes and open the targets.
  • Control enabled on workbooks opened manually; workbooks launched with U.LAUNCH_EXCEL are enabled automatically.

Step 1: Create an explicit launch control

Convert a labeled cell into a toggle and read its state separately.

=U.SET_CLICKVALS(B4,B4,1,0,{TRUE,FALSE},FALSE)

=U.GET_CLICKVAL(B6)

Step 2: Launch the target workbooks

Launch only when the user has enabled the control.

=IF(B7,U.LAUNCH_EXCEL(B10:B11))

Step 3: Apply a settings table

Pass the visible target/settings range to the controller and drive it from an explicit recalculation trigger.

=U.DO(U.CONTROL_EXCEL(B18:C29),U.NOW())

Step 4: Keep independent settings independent

Separate settings tables can target the same workbook; a later call does not imply that omitted settings are cleared.

Result

The controller workbook can launch each target, alter supported settings, and expose the control state without embedding target details in opaque nested formulas.

What’s Happening

What’s happening here?

The settings range is the control contract. Click values provide deliberate user intent, while U.DO and the trigger cell determine when changed settings are sent.