Type into - Text Box in excel Macro

Help
, , , ,
1

Hello,
I have an excel Input Text box as shown in the figure below. I want UIPath to type in the value through automation. Write cell activity does not work for Text boxes in excel.

image
I am trying to use the type into activity for the same. I have tried 3 ways so far:

  1. The selectors are not recognized when I use desktop/basic recording
  2. Anchor method - find image first and then type into - did not work.
  3. Context Aware anchor - did not work either.

Kindly help me with the same.

2

Hi @pratosha.hegde maybe you can try csv instead of excel. Then on your workflow you may use For each.

something like this.

image

2 Likes
3

Hi Gemlan,
Thank you for your response. I tried another way to fix this by using a one line macro code.
Sub Text(days_potential As String)
Worksheets(“Index”).TextBox1.Text = days_potential
End Sub
And this worked fine! :slight_smile:

2 Likes
4

Nice @pratosha.hegde

2 Likes
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.