Export Excel tabs into separate File

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

Developer

Accepted answers

binu_acs

@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

DifferentSheet_210423.yxzp

All comments

binu_acs

@DanielCarro One way of doing this

DifferentSheet_200423.yxzp

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?

binu_acs

@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

DifferentSheet_210423.yxzp

DanielCarro

Hi @binu_acs , it worked. Thank you very much

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703