Batch macro to pull data in

[aimeewilde]

Hi all - can someone help please? I have tried set up a batch macro to pull in 6 different tab from 5 different workbooks. Unfortunately, when I run the workflow it's just running one of the tabs from one of the workbooks 30 times (the file path from my batch macro input). I'm new to this so any help is appreciated! TIA

[OTrieger]

@aimeewilde 

I do not have the possibility to check your files, however as per what you wrote the issue is that the same file is opening over and over instead having the different files and different sheets. How did you set the Control Parameter in side the macro?

[ntakeda]

I cannot debug it, but I have reviewed it.
I noticed a few things, so here are my comments:

1. I think the selected area is incorrect. You should select the red-framed area. (Control Parameter should change value)

2.This may not be related to the current issue, I think these tools are not necessary.

 

[aimeewilde · Accepted solution]

I had hardcoded the control parameter, causing the loop. Thanks for helping