Recording Excel with Macro Enabled in LoadRunner | Record excel with load runner

To record an Excel sheet with macro enabled in LoadRunner, you will need to use a combination of the Windows Sockets protocol and the Microsoft Excel Add-In protocol. Here are the steps you can follow:

1. Open LoadRunner and create a new script.

2. In the Vuser Protocols dialog box, select "Windows Sockets" and click "OK".

3. In the Recording Options dialog box, select "Launch the following application" and enter the path to the Excel application with the macro enabled.

4. Click "Advanced" and select "Microsoft Excel Add-In" from the list of protocols.

5. Click "OK" to close the Advanced dialog box and "OK" again to close the Recording Options dialog box.

6. Start the recording process and perform the desired actions in Excel, including running the macro.

7. Stop the recording process and save the script.Once you have recorded the script, you can modify it to add the necessary parameters and data for your performance test, including any additional steps required to run the macro as part of the test.

Performance Testing automation in Azure Boards using JMeter

To perform performance testing in Azure Boards using JMeter tool, you can follow these steps:

1. Create a new repository in Azure DevOps that will hold the JMeter test plan file and any supporting files that are needed.

2. In the repository, create a new folder for the JMeter test plan and any supporting files. 

3. Add the JMeter test plan file and any supporting files to the folder.

4. Create a new build pipeline in Azure DevOps that will run the JMeter test.

5. Add the JMeter extension to the build pipeline.

6. Configure the JMeter extension to use the JMeter test plan file and any supporting files in the repository.

7. Set the build pipeline to run on a schedule or to trigger when a new build is created.

8. Run the build pipeline and view the JMeter test results in the build summary.

9. Analyze the test results and identify any performance issues that need to be addressed.

10. Use the insights gained from the test results to make improvements to the application or system under test.