You can use this action to open or create an Excel Sheet in a file that you’ve opened or created.

Open / Create Sheet

Description of the parameters:

number 1 ID Of Excel Window: The Id of the Excel file that you’ve opened or created in which want to create or open a sheet.

number 2 Sheet Name: By selecting this option, you can open or create a Sheet with its name. You can insert the name of the sheet in field that’s below this option or use the % sign to insert the variables you want.

number 3 Sheet Index: If instead of using the Sheet Name, you want to open it with its position, you can use this parameter. You can insert a number or use the % sign and insert a numeric variable.

number 4 Create Sheet If Does Not Exist: By selecting this option, if the Macro can not find the sheet, it will create one with the specified name.



Spread the word

Share to WhatsApp Share with Mail Share to Telegram
Share to Facebook Share to Linkedin Share to Twitter

Average score

Start Start Start Start Start

5 from 117


Rate this page

1
Voting Voting Voting Voting Voting