UiPath Macro Help needed

Help Activities
, ,
1

The business is providing an excel with an in built macro say A.
The macro contains one path that is dynamic.
I am planning to pass an arugument and use execute macro.
Please let me know how to achieve ?
I am also open to any alternate solutions.

2

@Ritaman_Baral

image
image690Ă—562 20.3 KB

cheers

3

I want to see the code.
The macro code where we are taking the argument as input

4

@Ritaman_Baral

you should have like this

Sub Macro_Name(FilePath As String) 

Inside can use the FilePath just as variable

End Sub

cheers

5

To pass an argument to a macro in UiPath, you can use the Execute macro activity. The Execute macro activity allows you to execute macros that are stored in Excel files.

To use the Execute macro activity, you will need to:

  1. Add the Execute macro activity to your workflow.
  2. In the Macro file property, specify the path to the Excel file that contains the macro.
  3. In the Macro name property, specify the name of the macro.
  4. In the Arguments property, specify the arguments that you want to pass to the macro.

Check this out to know on how to pass parameters to macro

Cheers @Ritaman_Baral

1 Like
6

There is one more scenarion.
The macro A has a dynamic path .
The bot needs to edit the macro in the excel itself.
how to do that ?

1 Like
7

@Ritaman_Baral

you just need to save the macro once with adding arguments and can be used

cheers

8

Well u can use excel application scope and use execute macro within that
Have a view in this thread with similar scenario and git resolved

Hope this helps

Cheers @Ritaman_Baral

9

Thanks.
The catch is I dont need to run the macro.
The bot needs to edit the path in the macro.

10

@Ritaman_Baral

May I know why do you want to edit path without running it?

Cheers

11

The business has provided the macro.
The macro has a path which needs to be edited

12

Hi @Ritaman_Baral

They provided the code in the Notepad file, open that notepad file and pass the argument as @Anil_G said in the vb code.

Hope it helps!!

13

Hi @Ritaman_Baral

Click on Developer->VisualBasic

image
image1502Ă—313 25.4 KB

image
image1500Ă—305 25.9 KB

In that you can find the Macro Code

image
image1920Ă—997 58.3 KB

Hope you understand!!

14

The excel is having in-built macro.

15

@Ritaman_Baral

The built in macro also can be edited …or you cna ask business to add the path argument

cheers

16

In that case…
The path will only be edited right ?
I dont want to run the macro…

17

@Ritaman_Baral

What you want to do with macro after editing?

can you please tell that

one alternative is give the input argument and when someone else is running he/she would get a prompt

cheers

18

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