Copy sheets into one book

[Eva]

Hi
I have number of workbooks in C:\My Documents and I would like to copy
sheet1 from all of them and paste it into new book. Is there a macro to do it?

 

[Luke M]

Check out Ron de Bruin's site:

http://www.rondebruin.nl/tips.htm

Specifically, his article on merging multiple workbooks:
http://msdn.microsoft.com/en-us/library/cc837974.aspx

 

[Eva]

Awsome
Thank you
--
Greatly appreciated
Eva

Check out Ron de Bruin's site:

http://www.rondebruin.nl/tips.htm

Specifically, his article on merging multiple workbooks:
http://msdn.microsoft.com/en-us/library/cc837974.aspx
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*