How can I create all sheets not tabs.

[Kinetic_analytics]

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

[binuacs]

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

[BS_THE_ANALYST · Accepted solution]

@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]

@binuacs yes

[Kinetic_analytics]

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

[binuacs · Accepted solution]

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

[Kinetic_analytics]

@binuacs Thank you.