Create filename from cell value

[mdara]

Hi all,

Example:

I have a file ABCD.xlsx with a sheet named Properties

Cell A1 on the Properties sheet contains a name, e.g., XYZ

I want to save the file as XYZ.xlsx

Is there a formula or tool that can save the workbook using the dynamic value in Properties!A1?

[jrlindem]

Using the formula tool, you can follow the format of:  \path\filename.xlsx|||sheetname

The trick is in the triple-pipes.  But you can definitely do this with a "cell" value.  If you need the A1 value from your input data, you can just use that in the final formula to create the output, but of course you can't reference something that's not already existing, so you'll have to put some though into how that Properties!A1 value comes into your workflow.

[Kottapally_Ramesh]

Here is the Output Path Logic :

[Name] + ".xlsx|||" + [Name]+ "$A1:z"

you can change the sheet name part second name part in the formula, and update the output tool config as per the attached workflow or screenshot. 

[flying008]

Hi, @mdara 

Because you are essentially renaming or copying an existing Excel file based on the value of cell A1 in a specific sheet, you may need to use the Run Command tool in Alteryx to achieve this requirement.

Spoiler

'@Rem 
@cd /d "' + FileGetDir([FileName]) + '"
copy /y "' + FileGetFileName([FileName]) + '.xlsx" "' + IIF(IsEmpty([F1]), 'Null', [F1]) + '.xlsx" 
@pause'