Archive of Mr Excel Message Board
Back to Errors in Excel archive index
Back to archive home
2 macro, 2 workbooks, an error msg.
Posted by amroo on May 23, 2001 5:40 AM
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
Re: 2 macro, 2 workbooks, an error msg.
Posted by Barrie Davidson on May 23, 2001 11:05 AM
Hi A+mroo, can you post your code. I'm having difficulty understanding what is happening on your end.
Barrie
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.