Export Excel tabs into separate File

[DanielCarro]

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

[binuacs]

@DanielCarro One way of doing this

[DanielCarro]

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?

[binuacs · Accepted solution]

@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

[DanielCarro]

Hi @binuacs , it worked. Thank you very much