Appending the results file.
Is there a way that we can append the results to the same results file? I am executing my script using schedule tasks every 15 min and my manager wants this to run for 1 month. But she wants all results in file.
Right now I am using
qtTest.LastRunResults.Datatable.exportsheet "C:\Documents and Settings\madhoo\Desktop\Search_" & myDateTime &".xls",Global
But this is creating a new .xls every 15 min and by the end of the month there will be around 1500 excel files. I have looked in help files but no luck.
Any help is greatly appreciated.
Re: Appending the results file.
You need to open the same file again and put the data a new tab instead. Do not use export sheet method. Use excel COM API to achieve the same. Search for Excel.Application on the forum