Hi,

I'm writing a macro to copy and paste value froms from 2 workbooks int
a third workbook. The filenames will vary according to month.
Let's say my files a "Summary Oct04.xls", "Mgt Oct04.xls" and "Boar
Oct04.xls". Obviously for November the filenames will be different.

How can I define these to the macro will copy from the relevan
worksheet to the correct workbook, regardless of the filename.

Any help would be appreciated.

Thanks,



--
bpmcco
-----------------------------------------------------------------------
bpmccoy's Profile: http://www.excelforum.com/member.php...fo&userid=1671
View this thread: http://www.excelforum.com/showthread.php?threadid=31922