copy sheet1 from all open workbooks to one workbook
 

How do I write a macro to copy sheet1 from all open workbooks to one
workbook?

Thanks
Mike

copy sheet1 from all open workbooks to one workbook
 

Found it at http://www.rondebruin.nl/copy33.htm

Thanks Ron!

Mike

"Mike" wrote in message
...
How do I write a macro to copy sheet1 from all open workbooks to one
workbook?

Thanks
Mike

copy sheet1 from all open workbooks to one workbook
 

Check out also the code that is using Dir Mike
http://www.rondebruin.nl/copy3.htm



--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Mike" wrote in message ...
Found it at http://www.rondebruin.nl/copy33.htm

Thanks Ron!

Mike

"Mike" wrote in message
...
How do I write a macro to copy sheet1 from all open workbooks to one
workbook?

Thanks
Mike