Rendering multiple sheets in excel in batch macro.

[Sunal2810]

Hi people,

I am trying to render multiple sheets in a single workbook using layout tool. It is working just fine. But when I am converting that whole workflow as a batch macro as my path is different for multiple datasets, the sheet names i am getting in my generated file is just Sheet1, Sheet2 and Sheet 3. Kindly help me out.

Attaching snippets for reference.

Thanks in advance.

    

[DawnDuong]

Hi @Sunal2810 

It's difficult to diagnose the issue from the pictures. Would you be able to attached a sanitized workflow with perhaps dummy data?

Dawn.

[jdminton]

I'm not sure if it answers your question as it's hard to tell from your data, but I typically use a formula tool to create the full path and sheet names to save to.