Saving QTP resultsin QC?

I'm having difficulty saving my QTP results in QC. I have multiple scripts that run sequentially in QC and using the same data sheet. For e.g.: scrpit1 creates a new user and puts the result in my .xls. script2 uses the user id to create an order. script3 cancels the order.

When script1 runs, where can I find the result .xls? I see it in the Report folder but not until AFTER the script completes. Is there a way to get the updated .xls BEFORE my script ends so I can upload it for script2 to use?

Any suggestions will be much appreciated.