Hi

I have two workbooks. One that always has the same name and the 2n
one that changes names constantly (I get tons of files through email)

How can I pass to a macro I have the name onf the workbook that alway
changes? In other words: I have the one that never changes open an
then I open the 2nd one, which always has a different name. When I ru
my macro, I need to be able to pass to the macro the name f the secon
workbook I just open

thanks in advance, :

--
halem
-----------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...nfo&userid=993
View this thread: http://www.excelforum.com/showthread.php?threadid=55012