How can I create all sheets not tabs.

Hello:

Great people. I want all output in separate sheets, not in tabs. Is there any way to inset all new sheets in table format in output?

Appreciate your help.

Thanks

Workflow

Accepted answers

@Kinetic_analytics
Change the file format output to CSV.
Set up a new Connection
This will output multiple CSVs for you!

i.e. output...

If not, you will probably have to use a batch macro to output multiple excel files.

@Kinetic_analytics Here is another way of creating the files separate and table format

@Kinetic_analytics you want the output in 8 different excel files?

@Kinetic_analytics
Change the file format output to CSV.
Set up a new Connection
This will output multiple CSVs for you!

i.e. output...

If not, you will probably have to use a batch macro to output multiple excel files.

@BS_THE_ANALYST You are effortlessly cool, brother! Thanks . Appreciate your help.

@Kinetic_analytics Here is another way of creating the files separate and table format

@binu_acs Thank you.