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.
Re: Hp load runner-testing a Excel sheet
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.