Excel Sheet to Schedule QC Test Sets

by efraim_taranto on ‎03-21-2013 06:47 AM

Hi All,


I've built the attached workbook and so far it has helped us to schedule QTP scripts using QC.


Hope you find it useful as well!

by sarahzhaoc on ‎10-10-2013 12:05 PM

the execel sheet is very nice, but can you show us how to use it so that we can benefit from your work?  Thanks

by on ‎11-13-2013 02:46 AM

I agree with sarahzhaoc.


Also what about the buttons?

by QTPFan1 on ‎12-06-2013 08:18 AM

Thanks for sharing the excel sheet... I am using a vbs file that works on same concept as the excel sheet..


But there is an issue with the "Test run scheduler" that we are currently facing.
Any help from you is really appreciated :)

Details about the issue:

We are using a VBS file to initiate QTP scripts execution.
Based on the script names we have listed in an excel file the VB file, using OTA concepts executes tests by using the scheduler.
The issue we are facing is the scheduler lists junk script names in the list every time we start a fresh execution.
Since we are dealing with scripts count of more than 100, every time the list in the scheduler grows in number due to listing of junk scripts that we executed in previous execution. Due to this QTP eventually crashes.
I was trying to find a way we could clear the scheduler list before every fresh execution. But for the TSScheduler object there seems to be no methods available to do this.
So please let me know if you are aware of any ways to clearing the scheduler list.
by on ‎02-01-2015 07:59 PM

set a flag with YES/NO in excel and add a condition - read the cell (flag value), If "YES" execute.

Showing results for 
Search instead for 
Do you mean 
HP Blog

The Future of Testing Blog


Follow Us
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation.