Using two Excel spreadsheets

[mv8167]

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

[Sathiya]

hi......
try to add the result(output)sheet in input sheet during run time.... then i doesnt do any overwrite....

[mv8167]

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