+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: Using two Excel spreadsheets (/Thread-Using-two-Excel-spreadsheets)
Using two Excel spreadsheets - mv8167 - 08-11-2011
How can I use two spreadsheets atone time. Currently I have one Excel spreadsheet open that will store my output data then I open a second that has my inut data. When I go to store my output data, I ofcourse over write my input data.
How can I change my code to use the output spreadsheet file?
Lorena
RE: Using two Excel spreadsheets - Sathiya - 08-12-2011
hi......
try to add the result(output)sheet in input sheet during run time.... then i doesnt do any overwrite....
RE: Using two Excel spreadsheets - mv8167 - 08-12-2011
Sathiya,
Thx for the help. But i am not sure of your meaning.
I do add both files at run time. I first add the output file to get it ready, then I bring the input file in to use. I tried to do this the other way (open input, then output) but this did not work as I need the output file to be created first.
Thx for your help.
Lor