2 macro, 2 workbooks, an error msg.

Bonjour, I have a first workbook with 3 sheets : Sh1 with 2 buttons for macro1 & macro2, Sh2 datatable for the operations of macro1,Sh3 datatable for the operations of macro2.The results are copying to a second workbook.When I click on the buttons of macro1 it runs, opened the second wrkbk copying the results;at the end I have 2 options : either I run the macro2 or I close the first wrkbk. If I run the macro2 an error msg said : that the second workbook is already opened so I have to save it and work on an other wrkbk. I don't want to lose the first results in closing the second wrkbk. What do I do ?
Thanks
A+mroo