Use macro from an other excel file

excel
macro

#1

Can we use a macro that we created in an excel file in an other one ?


#2

Hi Amine,
you can use a “parameter” in the macro where you will specify the workbook where the macro should run. Then you can pass this parameter from UiPath (store it in some input cell and read it back into the macro). It is not the nicest solution but it will work :slight_smile:


#3

Thx Jan I’ll try your suggestion.


#4

Hello, Jan

It is an additional question.
I think that setting a parameter to the macro from the property on the right, how should I describe it?
I’m sorry, please tell me.


#5

@jan Could you attach a sample?


#6

Hi Guys, sorry i havent checked the forum for a while so i missed this post :slight_smile: You can find the proposed solution in the attachment.RunMacro.zip (21.7 KB)