Excel Execute Macro

Help
1

Hi everyone , is it possible to execute this macro (select button) and pass the name of a country as a parameter, if not how can i automate these operation

2

Hi @hamza_sanssi

Without having access to the Excel, I am not sure if the button has a proper selector. However, you could probably try to run the underlying macro directly on the file.

Alternatively, you could use most likely use shortcuts to navigate to the button and then through the menus.

1 Like
3

thanx @loginerror here is the excel file

4

I was able to find selectors by using the UiAutomation framework in UiExplorer:

image
image1175×683 36.5 KB

This should already solve the issue :slight_smile:

1 Like
5

can u please ulpoad the main.xaml for me to get inspired , i face a big problem with selectors

6

Sure, see below:
ExcelSelector.zip (2.0 MB)

It attaches to the open Excel window.

2 Likes
7

does it work fine for ? cuz for me it doesn’t it still can’t find the element.

8

Do you have your Excel file open when running the workflow?

10

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