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.
No comments:
Post a Comment