File Browse for Output File with Multiple Excel tabs

[dtoothaker]

Hi Everyone,

I would like to prompt the user to identify the Output file name and location for an Excel file with multiple tabs. I need to be able to use a single prompt for multiple Output tools and have the Excel tab names defined in the workflow. Each Output currently uses a different tab on the same Excel file. I can prompt the user for the Output file, but it also prompts for the tab name. Using this configuration, a single tab is created instead of the different tabs identified in the Output tool. Has anyone else been able to get this to work?

Thanks,

dtoothaker

[T_Willins]

HI @dtoothaker,

Attached is an approach I would take.  By updating a Text Input instead of the Output Data tool directly and using an Append Fields to add the filepath, you can use a Formula tool to change the path to include the correct worksheet name.  The Select tool is to remove the worksheet name unless you want it to show in the Excel worksheet as a column.  Please note I changed the field type and field length for the filename in the Append Fields tool to V_String to accommodate longer complete filenames.