Rename Sheet Name to a Variable

Help
3

Hi @scott.luntz,
You can try below link for Rename sheet name:

Once you have rename the sheet follow below steps:

  1. Open Excel in the Excel Application Scope activity.

  2. Place a Get Workbook Sheets activity.

Get Workbook Sheets activity works only within Excel Application Scope activity.

3 Prepare a variable to store the acquired sheet name.

Select “Browse for Type

Enter “list” for “Type Name:”. Select “Systems.Collections.Generic List “.

Select “String” in the type selection

  1. Specify the variable prepared in “3.” in the Sheets property of the Get Workbook Sheets activity.

Place 5 For each activities.

Specify “String” for Type Argument, and specify “SheetsList” for Values.

The sheet name is displayed in the Output panel in the Write line activity.
Hope this helps, if it works mark as solution.
Thanks,
Neelima.