Batch Macro need to output to multiple Excel files

This has probably been answered but I'm not seeing my exact scenario. I have a batch macro. It's running the same process over and over but each time with a different Excel file as the input. I want to output each run into a different Excel file located at the same path. The file name I want to use for the Output Excel file is contained in a column within each of the Input Excel files. I got it to create a new tab for every run but I want separate Excel files for every run. In the Macro Output Data tool when I select "Create New Sheet", check "Take File/Table Name From Field", "Change Entire File Path" and "Field Containing File Name or Part of File Name" is set to "Client Name" (the field in each input Excel file that I want the Output Excel file to be named). These selections give an error of: "You must specify a sheet name."

Any idea? Thanks.

Common Use Cases

Accepted answers

Brad1

Resolved by adding a formula for mypath, myfile, and Full_Path

All comments

Brad1

Resolved by adding a formula for mypath, myfile, and Full_Path

ChrisCrombie

Hi Brad,

I'm glad you got this working. I'm trying to create almost the exact same scenario, but I can't seem to get mine to write the output files. It works when I do a single pass on the macro, but not when I try to pass in multiple filenames. I get no indication as to why it's not working but I suspect it's trying to Union the results when all I really want is a separate file for each iteration.

Do you mind sharing your solution so I can see where I'm going wrong?

Edit: I'm dropping my examples in if anyone has any ideas.

OpsConsoleBackUpMacro.yxmc

OpsConsoleBackUpOfTablesBeingDropped.yxmd

ckirgiz

Hello,

Is it possible to share your batch macro? I have the almost exact same task.

Thank you,

John

ckirgiz

I just realized that you said "I would try and scrub my workflow and upload it but it's just too massive for me to have time to do that." So I got my answer

Thanks,

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703