i can’t clik on the bouton when i open this excel file, i have this error. i tried with simulate click and send windows and it doesnt work.
But when the excel file is open and i run only click activity its working
Its a xlsm file
You don’t use UI Automation (click, type into, etc) inside Excel Application Scope. You shouldn’t use UI Automation at all to work on Excel files. You use the Excel activities - read range, write range, etc.
i have no choice, i need to click on the bouton if i want to read the cell.
I tried to use only read cell but it dosent work, when the bot open the excel file, its the first pop up window that appears
These are Excel issues, not UiPath issues. You need to resolve those connections so your Excel file works properly.
but i can’t click on the bouton why ?
If there is a solution to click on the bouton i will work
Even if you click the button you are not getting correct data in the Excel file because it cannot connect to the external data sources.
If you want to click the button you have to put in a Use Application/Browser activity, and inside it a Click. You can’t just put the Click inside Excel Application Scope.
What isn’t working?
Do you understand that even if you click that button, the Excel file will be incomplete?
My guess is that the application (excel in this case) won’t return a ready state since it’s waiting for the reply on the prompt. And, UiPath is waiting for the application to report ready before it will do a follow-up activity. So both applications locked in an endless staring contest.
To solve this use a second thread, a.k.a. a parallel activity, where the second branch monitors for this popup and clicks continue when it appears.
Be mindfull though, that if this popup is not consistent tahat you do need to build the proper checks and timeouts to capture all scenarios. Parallel activities can get messy real quickly.
@Jeroen_van_Loon
how can i do that plz ?
Yes but for me i just need to know how to click on this button on Excel
Use Application/Browser, indicate the popup, Click, indicate the button you want to click.
What does “it doesn’t work” mean?
@postwick
its not clicking on the popup button
Are you getting an error? Have you tried different input modes?
i tried i tried with many excel file and the result is the same
Are you getting an error? Have you tried different input modes?