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.
