How to copy sheet from Excel to another with a new sheet name

[Gokul001 (Gokul Balaji)]

Hi @Archie

Try to use Send Hotkey activity

Have a look on the thread

Copy and paste sheet in the same excel file with new name after/before a particular sheet

@Palaniyappan @erkanceylan @ImPratham45 Hey guys, I have found a work around using Hotkeys, I think it should work. For creating same copy of the sheet: Alt + E,M [E and M should be pressed one by one] Next/Previous sheet shortcut if needed Ctrl + Page down/up For Renaming the sheet Alt + H,O,R [H,O,R pressed one after the other] Thanks guys. Cheers Aryan

Alternative method

Use Read Range activity store the value in the Dt Variable

Use Write Range activity mention the new sheet name with Add header and pass the Dt variable

Regards
Gokul