M Mike Oct 31, 2003 #1 How do I write a macro to copy sheet1 from all open workbooks to one workbook? Thanks Mike
R Ron de Bruin Oct 31, 2003 #3 Check out also the code that is using Dir Mike http://www.rondebruin.nl/copy3.htm