Hey Folks,
Hope all are being safe!
i am Facing below error can somebody help me to get it fix?
Screen shared below for reference
this is the pop up
but when i opened excel and run the bot then bot able to find selector
Thanks a lot in advance
Govardhan
If you have done Find and Replace using UiAutomation, it needs Excel to be in open state. Can you post your excel sequence screenshot if it is not having sensitive information.
I was asking your workflow screenshot
@Sugumar8785 sorry, i was using basic activities PFB…
please check your selectors. Maybe the title is still there and when you open it, it can’t find the UI element.
i disabled title and tried still same issue bro
try to change selector mode (press F2 while indicating)
sometimes this helps with differences between debug and running mode
yeah @lena2505 thank you but in this case pop only not showing
Hi @GovardhanReddy
please share your Xaml file, if it doesn’t contain sensitive information to better understand where the issue is.
jhhh
Hi @GovardhanReddy, as @Sugumar8785 mentioned earlier, Excel file need to be open in order to run successfully or you can use the sample workflow i have provided, it will read the particular column you wanted to “Find and Replace” and then loops through one by one and replace it using the Regex and writes the data back to the same column.
this output shows the data being read from the excel file before replacing the “/”
output.txt (2.0 KB)
Workflow.
ExcelTest.zip (10.0 KB)
if you going through with 2nd option u can completely remove the multiple steps, as these works in the background
Thanks a lot and got it now
wat was solution
Time taken activity 
continue on errors works
Thanks for sharing
