Export Excel tabs into separate File
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi guys,
I need some help as I am struggling to get through.
So I have a spreadsheet with several country tabs 'Austria' 'Belgium' 'France', etc and each country need to be saved as a separate file which is located in a location, so Austria shall go into file B:\ABC\ABC Compliance\Alteryx\ABC drive output\Output\AT, Belgium will be the same path but \BE and France will be \FR, and so on.
I have read some posts but each one are slightly different and I tried to work on it but haven't succeeded. I tried using the Dynamic tool but didn't work out.
Much appreciated any guidance.
Kind Regards,
Dan
Solved! Go to Solution.
- Labels:
- Developer
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Binuacs,
Thank you for your response. The issue is that I don't have a column called 'Country' but the tab named by country. Instead of 'Country', is it possible to use 'Sheet Name'?
Although the first cell appears as:
In alteryx appears as:
Any thoughts?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@DanielCarro Updated the workflow and attached
also, update the formula inside the macro to get the correct file name. I only updated 3 countries and the abbreviations
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @binuacs , it worked. Thank you very much
![](/skins/images/1A7F54316481E10DBCA4A87A32E06CC6/responsive_peak/images/icon_anonymous_message.png)