App Interface selecting output path

[KyleF]

I am using the file browse in the app to change the output location. I am wanting the user to be able to select the file path but want to "force" the sheet name. It would be great if they didn't even have to input a sheet name in the app, but I don't mind if they do but it is just ignored and is forced in the process.

[T_Willins · Accepted solution]

Hi @KyleF 

Yes, you can force the sheet name.  The File Browse Interface tool will automatically ask for a sheet name (or List of Sheet Names) when selecting an Excel file, but you can use a formula in the Action tool to override the selected Sheet.  I used Sheet1 as the forced sheet in the example below.