Select Worksheet

Object to select the desired worksheet

Settings

This object depends on the use of the "New Excel" or "Open Excel" object to work.

Field

Descriptive

Title

Object title

Select Main Object

Option to select an Excel spreadsheet

Worksheet Name

Name of the worksheet to be selected

Example

To select a worksheet of an Excel file, you must have a pre-existing Excel file or create a file

1 - Select the "Open Excel" object from the "Excel" menu and drag it to your working area.

First you must define a unique name for the object in the "Object Identifier Name" field, inform the complete directory containing the name and the extension of the file and then set a password if it is required.

2 - Then select the "Select Sheet" object from the "Excel" menu, the main object defined when opening the Excel file and then define the name of the worksheet you wish to select:

3 - The working area will look like this:

PreviousSave As NextMake It Visible

Last updated 2 years ago

Was this helpful?