PDA

View Full Version : Move multiple sheets from multiple files



dubber
06-22-2010, 12:33 AM
Hello

I'm trying to use this macro to copy multiple sheets from multiple files. I have the files sales2010.xls, sales 2009.xls, sales 2008.xls. each contianing the sheet "sales". I would like to copy them into a new files with sheet names sales09, sales10,...

any sugestions?

thanks!


Admin edit: Moved from thread, referenced here: http://www.vbaexpress.com/forum/showthread.php?t=7003