Batch Macro seems to be stuck at the first row

[Phimpha]

Hello,

I tried to follow a tutorial to design a batch macro that copies a Excel template to several Excel files based on the name of the employee. Then we feed the sheet "Data" in each file so the file updates itself with the formatting of the template. However when i run the macros, the first one (which copies de template and is supposed to create 2 files for Jane and John) seems to run only on the first row.

Can you help me please !!!

Thank you very much

[Phimpha]

The tutorial I followed : Export to Excel with Alteryx - #02 Using Excel Templates - YouTube

[lynnesonney]

Hi @Phimpha  This may be a bit more complex than needed. Have you tried using the 'Output data - 'Take File/Table Name From Field'' Functionality?

it's actually the next video from the same individual on youtube. This can be used to generate separate files, as shown in the video, or separate tabs in the same excel based on a specific field in the data. 

https://www.youtube.com/watch?v=7uXMwORCPZg

happy to post a separate example if you think that would help!

[Qiu]

@Phimpha 
Maybe it is because you are using the path in OneDrive?
I simply modified the path to my local drive and it is working.