Select specific worksheet using Macro

[pokhan27]

Hi Expert, 

i have one input file but i want to have a macro that will give a user  to select the worksheet

for example: 

i have two sheets in a workbook and i want to create a macro that allows me to select the worksheet

[atcodedog05]

Hi @pokhan27 

Macro would be something like this

And workflow would be something like

Hope this helps : )

[pokhan27]

hi Thank you as always but you have hard coded the sheet name. is there any way to give user an authority to select the work sheet 

like below: 

you can see two input file from same source  which have two different worksheet. QTD and YTD. I want an app which gives me an option to select the worksheet 

hope you get that

[atcodedog05]

Hi @pokhan27 

Are you looking for a text box.

If you are saying drop down should automatically update with options only way is chained app. Because normal app wont change the interface options unless its run has a workflow once.

[atcodedog05]

Hi @pokhan27 

It would be something like this.

App1: Load sheet names

App2: Let user select sheetname

use this guide for downgrading the packaged workflow if needed.

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/... 

Hope this helps : )

[pokhan27]

hi 

this is my workflow. If i select QTD than the it goes to the QTD calculation and if i select YTD than YTD sheet should be selected

i 

[atcodedog05]

Hi @pokhan27 

You are in the right direction. Here is a simple app workflow how you can do it.

QTD:

YTD:

Combine the above scenarios of sheet selection and containers. I kind of feel your usecase seems to be quite more complex 😶

Hope this helps : )

[pokhan27]

i did came with this solution but am looking to have only one input file where user can select the sheet name

[atcodedog05]

Hi @pokhan27 

Wont the user be selecting the sheet in file browse tool connected to input tool 🤔

Can you share a more larger and clear snapshot. I am not able to take a good look into it.

[pokhan27]

just having worst case case scenario, don't want user to mix QTD data in YTD calculation  😉