How to use execute Macro


#1

Hi Guys,

Can anyone please let me know how to use an EXECUTE MACRO activity, As I need to run it at the end of process?


How to remove hyperlink in excel
Excel Macro with UI Path
#2

Create a Macro and save in a location and give full path of the same… it will execute


#3

As it says it takes macro name.

well i am not aware and have not tried with path it works or not. I have always tried it will only macro name till so far. :slight_smile:

Note - Can only be used in the Excel Application Scope activity.

Regards…!!
Aksh


#4

Yea correct, it is saying Macro name.
https://www.uipath.com/activities-guide/execute-macro

but i am curious how it detect the macro location, i am assuming macro must save in the same location where UiPath script saved.


#5

you are using it inside an excel application scope so if you will pass only macro name it will execute that macro.

Regards…!!
Aksh


#6

I tried it but its showing an error stating the Range does not exists. @aksh1yadav


#7

can you share your .xaml with that Excel Macro File?
Generally, that .xlsm file will have macro in its sheets, so click on any sheet to view the macro name,

Pass that macro name in Run Excel Macro Command, then it will be executed


#8

@pavan.vuntla

Try to run the macro with prefix as ThisWorkbook.YourMacroName if it is developed under Thisworkbook or SheetName.YourMacroname if it is inside particular sheet or just YourMacroName if it is created under Module.

Regards,
Ranjith.


How do I make user selection option in Runtime and xaml gets executed?
#9

Refer this post as well if nothing works


#10

Hey @pavan.vuntla

Well here i have a sample workflow for your understanding.

i have a sample macro excel enabled file having a macro to sum of two columns A and B so by using execute macro it will add those two columns value and will write that into the Col C.

sample_macro.zip (14.5 KB)

Note:- please enable macro alert if there will be a security warning will appear.


How to open macro enabled excel in uipath? read range or excel application scope activity is not working?
#11

thank you @aksh1yadav


#12

Hi,
I need a help in Excel-Macro

Clarification 1: Rows and Columns are treated as image. How to click a cell? Please refer the below screenshot
Clarification 2: I need to click and expand ALL the (+) symbol in the excel sheet. Is it possible in UiPath?
Clarification 3: I have to Read the “i” column which I have selected. How to do? Any guess are welcome

You also gave workflow with a .XLSM file. Even that also gives the same behaviour. Please refer the below screenshot.

Any idea will help me a lot.


#13

I need to consolidate the two columns in excel using macro.
can anyone know on how to do it.


#14

hi,
pls follow below ,

thanks,
Karthik.


#15