Macros are used to record the set of actions, save, run. Macros are used to save time on repetitive tasks when we do not want to do the same task every time. Macros can make wonders and we want you to experience those wonders with our Valorx Fusion.
To get started with this follow the below steps.
Open an Excel, click Start from Valorx Fusion Ribbon.
Follow the instruction provided to view the Developer option on the ribbon. Developer option is used to write macro in Excel
- Select File from the ribbon and click on Options.
- Select Customize the Ribbon from Excel Options.
- Select Developer and click OK.
Developer button will now show up on the Valorx Ribbon.
Open an app and click on Tasks and select Macros now click on New Macro Task. Below validation message will be displayed when there is no macro create on workbook or when Valorx Fusion is unable to access the macro settings. Follow the instruction provided under Information.
To get started with creating a macro follow the below steps.
- Select Developer from Valorx Fusion Ribbon.
- Click Macros and a dialog box will open.
Provide the name of the macro under Macro Name and click Create.
Now, write the macro in the provided box. Macro needs to be written between the "Sub" and "End Sub".
Once the macro is created now open a New Macro Task and provide the name of the Macro. Designers can choose the macros from Available Macros. Macro Task allows Valorx Fusion App to execute VBA hosted in the Excel file.