I have a macro excel with Refresh button after entering the data , I could enter the data but how to click on Refresh button, i tried Click, Click image activity etc but it didn't work

Learn Academy Feedback
1

I have a macro excel with Refresh button after entering the data , I could enter the data but how to click on Refresh button, i tried Click, Click image activity etc but it didn’t work,can anyone help to address it.

2

Hi @Subrayak87

Welcome to our UiPath Forum! :slight_smile:

Could you post a screenshot of this button? Would sending hotkeys be the solution using the Send Hotkey activity?

2 Likes
3

Hi @loginerror, Thanks for the response.

I have 2 issues here, if you can help to resolve that would be great -

  1. I am downloading the Macro from Internet then opening it using Excel Application Scope then I get pop up to Update, Don’t Update and Cancel options - i tried various activities be referring to some posts like Click image, wait element appears, attach window etc to click on the update button but didn’t work

  2. I manually handled the pop up then wrote on cell D10 and D12 successfully but couldn’t find a way to click on Refresh button (cell D16) but didn’t work

Can you help to provide solution on these 2 issues.

4

@Subrayak87

Buddy…!
yes you can refresh the file either by sendhot key or even executing a macro…

We have an activity called, execute macro, with which you can mention the macro name and parameters like,

image
image

And keep this inside the excel application scope.

Cheers…!

2 Likes
5

@Palaniyappan, I tried the Execute Macro but it didnt work. How to send hot key like what has to be select in hot key activities (such as Alt, Win etc) to click on Refresh button within the macro, can you be more specific please.

1 Like
6

Buddy, @Subrayak87,

kindly refer this zip file with xaml for running macro to refresh excel page.

Refresh.zip (1.6 KB)

Hope this would help u

Cheeers…!

2 Likes
7

@Palaniyappan Thanks for sharing the sample, I would like to demo the issue I am facing if you have time. Let me know if we can connect.