How to Rename sheets from Multiple Excel file and Save with new name of Sheets

[Puneet13]

Hello All,

Please help me to create macro to rename sheets form Multiple Excel file and Save with new name of Sheets

[KrishnaChithrathil]

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Naming-sheet-names-in-a-Workbook/td-p/...

Will this help?

[Puneet13]

Hi Krishna i have multiple excel files which is having multiple sheet  i want to change the all sheet name with "Sheet1", every file having one sheet.

[Puneet13]

Use VB Script for Rename multiple sheet from multiple files in Alteryx

1. Add Run Command Tool in Alteryx.

2. Configuration window of the Run Command.

3. Write Source - Workflow_temp.yxdb

4. Run External Program Command: cscript.

5. Command Argument: ".\VBA_Example.vbs"

6. Working Directory: %Engine.WorkflowDirectory%

7. Run minimized - checked

8. Run Silent - checked

9. Read result: Macro VB Script code path.xlsm