SOLVED
How can I create all sheets not tabs.
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Kinetic_analytics
11 - Bolide
‎02-22-2023
10:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Workflow
6 REPLIES 6
binuacs
21 - Polaris
‎02-22-2023
11:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Kinetic_analytics you want the output in 8 different excel files?
14 - Magnetar
‎02-22-2023
11:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
‎02-22-2023
11:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs yes
‎02-22-2023
11:53 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@BS_THE_ANALYST You are effortlessly cool, brother! Thanks . Appreciate your help.
binuacs
21 - Polaris
‎02-22-2023
12:42 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎02-22-2023
12:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@binuacs Thank you.
