Highlighted
Absent Member.
Absent Member.
369 views

Hp load runner-testing a Excel sheet

I am testing a Excel sheet which has Macros embedded(created using VB Scripts) that connect to a SQL Server database and retrieve and add some data. I have tried recording the script using various protocols ,but no steps are recorded, I am using Load runner 12 and the Excel version is MS Excel 2016. Please let me know if possible how to record scripts with excel files and what protocol is needed.

0 Likes
1 Reply
Highlighted
Honored Contributor.
Honored Contributor.

Re: Hp load runner-testing a Excel sheet

Hello,

I had similar kind of sceanrios. Try using fiddler and check if you able to capture any traffic. If yes, convert fiddler to vugen script and u can run the load test.

If fiddler is unable to capture any traffic then i think LR doesnot support excel recording. 

Correct me if wrong.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.