Repeat Run Speadsheet macro for all files in a folder

RPA Discussions
1

Hi,

I have a folder with 10 .xls files that all have the same macro within them. I want to run that macro for all of them using “For Each File in Folder” activity and save the changes/results.

However, the macro name in “Assign Macro” is dynamic per each file (XYZ123 Fund Trend , ZYX321 Fund Trend , ABC123 Fund Trend , CBA321 Fund Trend, etc, etc). How can I run all the dynamic macros using “For Each File in Folder” activity?

image

2

found solution on Google