Creating A New Sheet in Excel With A Custom Name

How to create a new sheet and give it a custom name in Excel?

There is no direct activity available to create a new sheet. However, the same shortcut keys a human user would pass to Excel via a sequence of hotkey activities can be passed, that will simulate the process of creating a new sheet.

The following steps are recommendations to achieve this method of creating a new sheet:

1. Use excel application scope. 

2. Hotkey (shift+F11) Activate and click before typing checked


3. Hotkey (alt+H) Activate and click before typing checked


4. Hotkey(o) Activate and click before typing unchecked

 

5. Hotkey(r) Activate and click before typing unchecked


6. Type into("sheetname") activate checked

7. Hotkey (enter) Activate and click before typing unchecked


8. Hotkey(ctrl+s) activate checked (Optional step to save the excel file)