Configuring dynamic anchor and targets in Studio 2025 Modern

Help StudioX
1

:sos_button: Request for Help: Dynamic Click to Update Embedded Excel Textboxes Fails to Iterate in Loop (UiPath Studio 2025 Modern)

:white_check_mark: Objective

We are trying to automate the update of embedded ActiveX textboxes inside a macro-enabled Excel workbook using UiPath Studio 2025 Modern experience.

The CSV contains:

  • targetCell: the Excel cell where the textbox is located (e.g., E11, E12…)
  • textToInsert: the text we want to paste into each textbox

We want to:

  1. Loop through all rows in the CSV.
  2. For each row:
  • Double-click the specified cell (from targetCell) to activate the textbox.
  • Ctrl+A, Delete, then paste textToInsert.
  • Press Enter.

:test_tube: What We’ve Tried

  • Used For Each Row in CSV data.
  • Used Click with Strict Selector dynamically built as:
    xml
    CopyEdit
* or: vb CopyEdit

“”

  • Set Click Type to DoubleClick, Input Mode to Hardware Events.
  • Verified the UI tree has format.
  • Scope of targetCell is set to Main.
  • Tried different selector combinations, including removing idx, switching to fuzzy selectors, omitting parent elements.
  • Ensured delays are added for Excel to load (tried with 30 seconds).
  • Issue persists: UiPath clicks only on the first row’s targetCell, opens the textbox, then exits or fails. Loop does not iterate properly.

:cross_mark: Symptoms

  • Only E11 gets activated no matter what targetCell is.
  • “Object reference not set to an instance of an object” or selector not found errors.
  • After forcing selector, “Desktop” or unrelated pane is targeted.
  • Click doesn’t dynamically update — always tied to original element unless manually reindicated.

:sos_button: Help Needed

  • How can we properly configure the Click activity in UiPath 2025 Modern to dynamically double-click a different Excel cell per loop iteration?
  • Why does the loop not re-evaluate the selector even though targetCell changes?
  • Is there a better alternative for triggering and updating embedded Excel textboxes reliably?
2

Hi @Yong_Km

ActiveX textboxes in Excel aren’t linked to specific cells—they just float on top of the sheet. So, using clicks to open and edit them in UiPath is unreliable and can easily break.

A better and more stable way is to update these textboxes using code, like Invoke VBA or Invoke Code in UiPath. This lets you directly change the textbox content without needing to click anything.

Hope this helps!
please provide the sample input and output we could help more!

3

but the excel sheet is on macro and compiled and I dont have the password. Injecting via codes into the sheet is impossible will invoke VBA works here?

4

the box is embedded in a cell and there has been successes in opening up the box via double clicking left mouse using the “click” activity. Just that the target stays at one cell/box and cannot move from there..