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.
Solved! Go to 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.