New Macro
Object to create a VBA macro.
Last updated
Object to create a VBA macro.
Last updated
This object depends either on the "New Excel" or on the "Open Excel" objects to work.
Field
Descriptive
Title
Object Title
Object Identifier Name
Singular object name of the object to create the macro in Excel
Select Main Object
Option to select an Excel sheet
Macro Name
Macro name
Run Macro
Execute the created macro
Select Cells
Select the cells for the macro execution
Starting Cell
Initial cell of the selection
Final Cell
Final selection cell
Script
VBA Script
To create a new macro in an Excel spreadsheet file you need to follow a few steps with a pre-existing 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 you should select the "New Macro" object in the "Excel" menu, define a unique name for the object in the "Object Identifier Name" field, select the main object defined when opening the Excel file, define the macro name, select the "Run Macro" option and then write the VBA script.
Caso selecionada a opção "Executar Macro", será exibida a opção "Selecionar Células". Ao selecionar essa opção, será necessário informar o valor para a "Célula Inicial" e "Célula Final" para a execução da macro. - If you select the "Run Macro" option, the "Select Cells" option will be displayed. When you select this option, you will need to enter the values for the "Starting Cell" and the "Final Cell" fields.
