Hold left click down for a certain period of time

Hello, I need to hold the left click down to scroll right instead of hitting the left button 100 times until I achieve the column that I want to modify. Since I am using the “Text to Columns” activity inside Excel and the file is all in column A before I input the element that separates the columns I need to achieve the column by clicking the right arrow so I can modify it to “Text”.

How can I set the period of time that I want the left button clicking the right arrow?

you can try using vba instead

  1. copy below code to text file e.g. vba.txt
  2. in excel application scope, call invoke vba activity
  • codeFIlePath = “vba.txt”
  • EntryMethodName” = “ColumnToText”
  • EntryMethodParameters = {ColumnLetter, SheetName} e.g. {"Z", "Sheet1"} to turn column Z in sheet1 to text format
Function ColumnToText(columnLetter As String, sheetName As String)

Range(columnLetter & ":" & columnLetter).Select
Selection.TextToColumns Destination:=Range(columnLetter & "1"), DataType:=xlDelimited, _
    TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
    Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
    :=Array(1, 2), TrailingMinusNumbers:=True
Selection.NumberFormat = "@"
End Function

you can also use custom activity

Hey @Thiago_Ayusso

What I understood now, is you have a CSV or Excel with some data having headers.

You want to only pick one column from it ?

Is that correct ?

If the above is clarified, I believe there is a better way to do with UiPath activities instead of UI automation.

Kindly confirm.


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