I have 2 excel files (excel1 and excel2). excel 1 has data and a Run button. when pressing the Run button, delete the old data and open the path selection window. and then select excel 2 to get the data. but when I got to the path, I couldn’t choose the excel 2 path. I tried “select files” activity and “click” activity but still can not. please help
Welcome to the community.
Try using type into activity after a click.
thank for replied. i tried “type into” activity and “click” activity but still can not
Could you please share some screenshot or code file on what are you exactly trying.
I’ve already opened the file. But there was another error. That is when opening the second file, it does not work but errors at the click button open. I edited the selecter of the open click button step and ran very well. so the problem is probably in the second file. please help me
Try typing the whole path along with filename + Enter key in Type into.
This may help
Now, I have already opened the file and am going to work with it. In excel 2, there is an input box showing the range I selected (range from column B to any column - row B2 to B20 is fixed, select only column) then click OK at the input box to paste the selected value into excel 1. That is my current problem. please help