I have created a batch macro to pull the data from all of the sheets from an excel file, However it is taking the data only from the one sheet and not from all of them.
Please guide. Struggling To get this from 3 hours..
Sorry, no, scrap that. You need to create a list of sheet names to feed into the batch macro. You could do this my running the macro twice, like this
example attached
I can't see your macro, but it's probably as simple as putting a browse tool after your macro in the workflow.
Hi @moinshaik,
I'd agree with @DavidP. When creating an iterative or batch macro if you don't put a browse tool after you will just see the first "iteration" or "run" of the macro and therefore not see all results from the run.
If this solves your issue please mark the answer as correct, if not let me know!
Regards,
Jonathan
