Running multiple files one at a time from a single location through a workflow

[rmt1g13]

Hi afv2688,

Apologies for the confusion here, I didn't explain it very well.

I have set up the macro, which looks like this: 

When running this workflow, the run takes around 2 to 3 seconds and works fine. From here I run the macro from another workflow with the multiple file input: 

This then takes around 1 hour if not more to run. Do you see anything I might have done wrong here?

Thanks again for your help.